Correlating Date to tab number
 

I have a workbook that contains 31 tabs (for each day of the month). I need
to lookup data in the tab for the current day. Currently I have a seperate
workbook that will contain all the macros and one of it's sheets that
contains a =now() that has been formated to display the day and that's all.

How do I make the macro look at the date on the one workbook and use that as
ref to what day (31 tabs) on the other workbook? So that if today is the 2nd,
the macro would open the monthly workbook and go to the #2 tab and look at
C10.

Many thanks in advance....
-EW - Analyst

Correlating Date to tab number
 

If you named the worksheets: 1, 2, ... 31

=vlookup(a1,indirect("'"&day(today())&"'!A:E"),3,f alse)





ewagz wrote:

I have a workbook that contains 31 tabs (for each day of the month). I need
to lookup data in the tab for the current day. Currently I have a seperate
workbook that will contain all the macros and one of it's sheets that
contains a =now() that has been formated to display the day and that's all.

How do I make the macro look at the date on the one workbook and use that as
ref to what day (31 tabs) on the other workbook? So that if today is the 2nd,
the macro would open the monthly workbook and go to the #2 tab and look at
C10.

Many thanks in advance....
-EW - Analyst

--

Dave Peterson