Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 14th 05, 03:43 PM
JG_HILL
 
Posts: n/a
Default 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   Report Post  
Old May 14th 05, 07:12 PM
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 chart does not update when worksheet data changes proquant Charts and Charting in Excel 1 June 15th 05 12:23 AM
Open workbook to specific worksheet Dave Excel Discussion (Misc queries) 2 May 2nd 05 08:44 PM
How do I collect data from an interactive web worksheet and impor. worksheetmom Excel Discussion (Misc queries) 3 February 20th 05 01:38 AM
Multiple worksheet queries liam Excel Worksheet Functions 3 February 16th 05 07:52 PM
Reference Data in Moved Worksheet tommcbrny Setting up and Configuration of Excel 1 December 1st 04 07:49 PM


All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017