Inputting SAME formula within EVERY (ALL) Worksheet
How do you get a value within a cell to increment, by say, 1, for each and
every worksheet within my workbook? For example, the value in sheet1 in cell A1 is 100 in sheet2, I input...= 1 + 'sheet1'!A1 in cell A1 (value now is 101) then, in sheet 3, I input...= 1 + 'sheet2'!A1 in cell A1 (value now is 102) then, in sheet 4, I input...= 1 + 'sheet3'!A1 in cell A1 (value now is 103) etc.,etc.,etc. How can I input a formula...then copy and paste it into my sheets without having to go to each and every worksheet to input the formula?? Thank you, FLKulchar |
See one answer to your previous posting under another subject line.
Gord Dibben Excel MVP On Thu, 29 Sep 2005 17:06:02 -0700, FLKULCHAR wrote: How do you get a value within a cell to increment, by say, 1, for each and every worksheet within my workbook? For example, the value in sheet1 in cell A1 is 100 in sheet2, I input...= 1 + 'sheet1'!A1 in cell A1 (value now is 101) then, in sheet 3, I input...= 1 + 'sheet2'!A1 in cell A1 (value now is 102) then, in sheet 4, I input...= 1 + 'sheet3'!A1 in cell A1 (value now is 103) etc.,etc.,etc. How can I input a formula...then copy and paste it into my sheets without having to go to each and every worksheet to input the formula?? Thank you, FLKulchar |
All times are GMT +1. The time now is 03:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com