Extracting Rows with Todays Date

[SuddathAL]

I work with a spreadsheet every day that has a tab for each of 3 different modes of transportation that is regularly added to and updated. In each tab there are 3 columns that contain dates, one for load, pick up and delivery. What I am trying to do is find a way to extract every row that has todays date to a "Day Page" tab.

The macro would have to search 3 columns on 3 tabs and pull each row with todays date and copy it to a new tab. If it is possible to have it search for tomorrows date as well that would be great.

Thanks for any help you may be able to give.

 

[Dharris144]

Just use an Hlookup formula. In the tab you want today's dates enter a hlookup formula that finds todays date then enters the data.