I have dates in column B that has been sorted so all date are in sequence. Is there a way to select a cell and have all the rows that all have that date selected for me? I would like to cut them out, (shifting up) and move them to another sheet tab and place these new rows inserting them at row 8 of a different page, pasting in only values and killing the formulas in the rows. (shifting everything down) Would like to do this for one day at a time, instead of archive all at once.
How do I get Excel to search for the block of dates equal to the date that I start with? I want to put a rule in there that says, the date has to be at least a week old. Please advise and thanks.