If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a log in a workbook
I have a workbook with sheet 1 thru sheet 31, sheets 1 thru 30 are formatted
identical except that there are different values in the cells, ie cell a1 on sheet 1 the value is contractor A, sheet 2 cell a1 the value is contractor B. what i would like to do is have sheet 31 be a log so that i can see at a glance what is on sheet 1 thru sheet 30 cel a1. so i copied cell a1 on sheet 1 and pasted it to sheet 31 and linked the cells, i then filled down but had to change the sheet # in each cell because it picked up sheet 1 all the way down the fill. how can i accomplish this without having to type in every cell. |
#2
|
|||
|
|||
Creating a log in a workbook
Barry
Stay with the same thread. Same answer to this post as to your other posts. Use the INDIRECT function. Gord Dibben MS Excel MVP On Wed, 5 Jul 2006 09:59:01 -0700, barry wrote: I have a workbook with sheet 1 thru sheet 31, sheets 1 thru 30 are formatted identical except that there are different values in the cells, ie cell a1 on sheet 1 the value is contractor A, sheet 2 cell a1 the value is contractor B. what i would like to do is have sheet 31 be a log so that i can see at a glance what is on sheet 1 thru sheet 30 cel a1. so i copied cell a1 on sheet 1 and pasted it to sheet 31 and linked the cells, i then filled down but had to change the sheet # in each cell because it picked up sheet 1 all the way down the fill. how can i accomplish this without having to type in every cell. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Bill O'Neal | Worksheet Functions | 8 | August 14th, 2009 11:36 PM |
Linking a cell to another workbook cell based on a variable name | Brian | General Discussion | 6 | June 1st, 2005 11:54 PM |
Playing a macro from another workbook | Jim | General Discussion | 1 | February 23rd, 2005 10:12 PM |
How to hyperlink from a workbook to sheets in another workbook? | MJOHNSON | Worksheet Functions | 0 | February 17th, 2005 08:31 PM |
?- Creating a "parts order" list from a workbook | Mario | Worksheet Functions | 6 | December 29th, 2003 05:49 PM |