Home |
Search |
Today's Posts |
#1
|
|||
|
|||
print report with data from specific worksheet
I have a workbook with multiple sheets. The first sheet contains a report
that I need to print using data from a specific sheet that changes each month. For example, the report for January needs to pull data from the sheet named Jan. When it's June the report needs to pull data from the June sheet. Since I know the date how can I automate getting data from the correct sheet? |
#2
|
|||
|
|||
I think you want to use the =indirect() function.
You could put the month abbreviation in A1 of that sheet. Then use formulas like: =indirect("'" & $a$1 & "'!B99") to retrieve the value from B99 of the sheet named in A1. Type the month abreviation into A1 and all the formulas will "adjust" to point at that worksheet. JG_HILL wrote: I have a workbook with multiple sheets. The first sheet contains a report that I need to print using data from a specific sheet that changes each month. For example, the report for January needs to pull data from the sheet named Jan. When it's June the report needs to pull data from the June sheet. Since I know the date how can I automate getting data from the correct sheet? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Open workbook to specific worksheet | Excel Discussion (Misc queries) | |||
How do I collect data from an interactive web worksheet and impor. | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel |