Ask Me Help Desk - A way to make info in spreadsheet delete automatically

Quote:

Originally Posted by ScottGem

Why would you put both the date and reason in the same cell? That's going to make it much more difficult to determine what the date of the record is.

Why would you want a row with just a name in it? That just makes no sense to me.

Well that's just how they did it to begin with unfortunately. Since I can't "re-create" the spreadsheet, I'm afraid I'm stuck with trying to work with what they gave me. But it sure would be nice to figure out some way to save myself from having to go find all the old stuff manually 3 or 6 months down the road if possible.

Personally, I'm with you, I would've done it differently from the get-go, but my hands are tied.

Each row is for a different name. So if someone is always on time, their row will always be blank. But if a different person has a habit of arriving 15 min late every other day, their row would be showing a lot of dates/reasons in it.

Let me see if I follow you. The spreadsheet has a ROW for each employee. You then add a column to the right of the name with both the date and reason?

If that's your structure, then it would take some complex VBA to loop through each cell in each row and remove the old entries.

I really thinki you need to change the structure of this cumbersome setup. You can always create a pivot table to display the data in the Row and column setup.

Quote:

Originally Posted by ScottGem

Let me see if I follow you. The spreadsheet has a ROW for each employee. You then add a column to the right of the name with both the date and reason?

If that's your structure, then it would take some complex VBA to loop through each cell in each row and remove the old entries.

I really thinki you need to change the structure of this cumbersome setup. You can always create a pivot table to display the data in the Row and column setup.

Yes, that's the correct structure. So there isn't a way to just make the spreadsheet search through all the columns for a date 3 months old that is combined with "tardy"? I wish I could change to some other setup, but my hands are tied unfortunately. The most I can hope to change is a formula or macro or something else that doesn't involve starting all over from scratch.