Formula Help

[chew]

I want to have formulas set-up in my spread sheet so when a new sheet is added, I do not have to manually change the Sheet names to keep my spread sheet the way I need it. I have tried linking the cells, but it is too tedious to change all the sheet names in the formulas for new sheets. Is there a formula or function that can be written in excel? I basically want to avoid having to click on a cell in say Sheet5, insert "=" and then select the cell in another sheet I want to have data imported from.

For example, Sheet1, cell H14 formula is: sum(H12:H13). Sheet2, cell H13 needs to have the data value from Sheet1, cell H14 inserted into it. Sheet2, cell F19 needs to have the data value from Sheet1, F19 added to what is in Sheet2, cell C19.

Is this even possible? If the sheet needs to be emailed to someone, I can do provide it if it makes this any easier.

Thanks in advance for any help.

Donny

 

[Joe4]

Please continue in your original thread:
http://www.mrexcel.com/forum/showthread.php?t=487057

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted:
http://www.mrexcel.com/forum/showthread.php?t=127080