snoopaloop
asked on
excel move automatically expired dates (row) to second sheet
Hi, I'm trying to get rows in my spreadsheet to move to another sheet once the dates expired. Here is an example row of a date expired. I want this yanked automatically and place on sheet two. Can you help? please...
ALL ABOUT PRESERVATION 12/9/2012 1/18/2013
ALL ABOUT PRESERVATION 12/9/2012 1/18/2013
Hmmm doesn't look like that will work, I guess I would use conditional formatting.
That should be able to color a cell based on the date compared to today, and then just filter the color that has expired instead of based on date.
If you are using Excel 2010 that should work. If you have to do it with VBA that is going to be a different approach.
That should be able to color a cell based on the date compared to today, and then just filter the color that has expired instead of based on date.
If you are using Excel 2010 that should work. If you have to do it with VBA that is going to be a different approach.
ASKER
Im not sure what that means can you explain??
what version of Excel are you using?
ASKER
Excel 2010
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THere's a fix that the other IT consultant used to resolve it. I would get that info tomorrow.
You could create two spreadsheets, and filter them both by >now() or <now() depending on the sheet. That might work if now is allowed as a filter.
That could have the effect of making them look like they move.
-SA