Test Workbook.xlsx
I have a spreadsheet with columns A through O. Columns A through N have one piece of information in them. Column O contains multiple rows of cells with dates in them. I need to delete all dates before 1/1/2011 and after 6/30/2011. I tried using Delete Sheet Row; it seemed to work but then data further down in other columns was missing.
Doing it automatically would be nice as the real spreadsheet has about 600 cases, but I don't care if I have to do it one case at a time. Anyone have any ideas?
Thanks!
Bookmarks