Copying rows & Renaming Spread Sheets

[jgupte]

I have a spreadsheet that I need to update every day from another spreadsheet.

The second sheet has multiple rows containing data, sorted by date, starting with today's date and going for the next two weeks or so.

I need to copy all rows with a date GREATER than today's date to the first spread sheet.

How can I select all rows with the date (in column F) to be copied?

I tried using a macro to pick up =TODAY() + 1 but don't know how to put it into the FIND function. I get the text string "1/06/2012", which wuld work today, but not tomorrow.

I also need to rename the second spread sheet as it comes with a name like "HRW Update Data - 31 May 2012" (the date is changed every day), and in order to use a macro to change between spread sheets, I need to use a standard name.

What I would like to do is

Thanks for any advice.

Cheers,

Julio