MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying selected dated rows between sheets


Posted by Barry on March 20, 2001 1:18 PM

I need to identify overdue dates in a column on one sheet and then transfer all of the contents of that row onto a reminder sheet.


Posted by Bob on March 20, 2001 2:05 PM

You could autofilter out the dates you want, select all, CTRL G, Special, visible cells only, then copy those cells and paste them onto another sheet.