Kevin,
Advance filter can do it.
visit
http://www.contextures.com/xladvfilter01.html
for details.
Cecil

"Kevin .." wrote in message
om...
Hi

I am trying to automatically populate a worksheet from data contained
in another based on the dates today and today + 1.

There will be multiple rows with elegible data. The date will be in
column A.

In simple terms it would look something like this.

In Spreadsheet A, Column A
Where Date = Today and Date = Today + 1
Copy all those rows to Spreadsheet B.

I am wondering if anybody can help with this.

Many thanks all.