Help with summary page

March 2, 2011 at 07:32:56
Specs: Windows 7
I would like to create a summary page from several sheets in a workbook. Column A has the dates, column B the data for that day. I would like the summary sheet to show the number in column B of each sheet for the current day. In other words, when I open the sheet on March 18th, I would like the summary sheet to show the data in column B that corresponds to March 18th.

See More: Help with summary page

Report •

March 2, 2011 at 09:42:35
I would use a lookup feature with the function for today's date as the lookup. Insert the function for the date into a cell and use the cell as a reference in the lookup.

A1 = today()

Use the lookup function with the reference to A1 to look on A and display column B ...


Just to explain a bit more - use the date from A1 to look in all of column A (on the identification worksheet) and place the data from column B in that same worksheet in the cell of the summary worksheet.

I'm still learning everyday.

Report •
Related Solutions

Ask Question