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