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? |
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 |
All times are GMT +1. The time now is 09:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com