Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jaytee
 
Posts: n/a
Default Filling cells on a summary page

To set the scene:
31 tabs, one for each day in a month. One tab that says "summary". Each
daily tab boils down call volume by hour. The Summary tab will gather that
data by day. Therefore, on the summary tab, I have the days of the month,
1-31, across the top, and the phone cubicles down the left side.
So,column 1 is titles, column 2 shows data from tab "1", and column 3 shows
data from tab "2".
My Problem: when I drag the column 2 formula across, I need it to
automatically change the tab protion of the reference to the next successive
tab.

Can it be done?
  #2   Report Post  
Nige
 
Posts: n/a
Default

See if this works:

=INDIRECT("Sheet" & COLUMN()-1 & "!A1")

This assumes the tabs/worksheets are called Sheet1, Sheet2 etc.., that this
formula is in in the second column of the first worksheet , and that the
total or whatever you want is in cell A1 in all the other sheets, but maybe
you can adapt it.

If your worksheets are just called 1, 2 etc then just take out the "Sheet" &
part.

Nige


"Jaytee" wrote:

To set the scene:
31 tabs, one for each day in a month. One tab that says "summary". Each
daily tab boils down call volume by hour. The Summary tab will gather that
data by day. Therefore, on the summary tab, I have the days of the month,
1-31, across the top, and the phone cubicles down the left side.
So,column 1 is titles, column 2 shows data from tab "1", and column 3 shows
data from tab "2".
My Problem: when I drag the column 2 formula across, I need it to
automatically change the tab protion of the reference to the next successive
tab.

Can it be done?

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
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 10:29 AM
How do I get custom colors for filling cells in Excel? David Grant New Users to Excel 3 January 28th 05 10:17 PM
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 16th 05 12:14 AM
instead of moving cells my arrow keys scroll the page dgray Excel Discussion (Misc queries) 2 December 22nd 04 03:01 PM
How do I freeze or lock cells to show up on each page without typ. [email protected] Excel Discussion (Misc queries) 1 December 7th 04 06:22 AM


All times are GMT +1. The time now is 05:51 AM.

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

About Us

"It's about Microsoft Excel"