Moving only certain dates by formula to other sheet

[ShannaP]

Hi

I have a multi tab worksheet where i am trying to move only certain dates over to the main page. I have made a box for the current day and found a way around for that but would like to be able to say "give me everything done on the 12/15/08" and move that over to the main page and in order by date with out any gaps in rows where dates not needed are.

One note left when I asked this last week says to upload the file to look at but I dont see where to attach the file.


Thanks for the advise.
ShannaP

[mdbct]

In order to attach a file, scroll down below the text box where you entered your post and you will see an "Additional Options" area. Click on the Manage Attachment button in the Attach File region to browse for your file.

You can see the "Additional Options" area when you start a new thread or when you choose to "Post Reply", but not when you use the Quick Reply area.

[mdbct]

The following will cycle through all sheets of a workbook (except the first sheet) and copy any rows that have the desired date in the A column to the first sheet. The input box defaults to the date which the macro runs.

Please Login or Register  to view this content.