| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is there a forumla to link an absolute cell reference in multiple.
I have an ablsolute cell reference (for example Cell A1) on 10 different
sheets in my workbook. I want to know if theres a formula I can copy down that will pull cell A1 from each of the sheets. Is there a way to do this without manually clicking the cell on each sheet? |
|
#2
|
|||
|
|||
|
Hi Thomas
what are your sheet names? (an example of 2 or 3 will do) Cheers JulieD "Thomas" wrote in message ... I have an ablsolute cell reference (for example Cell A1) on 10 different sheets in my workbook. I want to know if theres a formula I can copy down that will pull cell A1 from each of the sheets. Is there a way to do this without manually clicking the cell on each sheet? |
|
#3
|
|||
|
|||
|
If your sheets have the default XL names, you could try this:
=INDIRECT("sheet"&ROW(A1)&"!A1") And drag down to copy. To simply add them together, try this: =SUM(Sheet1:Sheet10!A1) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Thomas" wrote in message ... I have an ablsolute cell reference (for example Cell A1) on 10 different sheets in my workbook. I want to know if theres a formula I can copy down that will pull cell A1 from each of the sheets. Is there a way to do this without manually clicking the cell on each sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Link to a cell in another workbook by name rather than absolute c. | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| How do I link an identical cell address across multiple worksheet. | Excel Worksheet Functions | |||
| Replace a sheetname with a cell reference to link to another work. | Excel Worksheet Functions | |||
Linear Mode
