Linking Cells??

[chew]

I am having a problem with linking cells.

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

 

[chuf]

Click in the cell that you want the answer to arrive in.

then enter an = sign

then click in the cell where the value is - that is, where its coming from.

then hit return.

that should link the cells.

Hopefully. HTH Chuf

 

[chew]

Thanks Chuf. I have tried that, but you still have to change the sheet names when you insert a new sheet. It gets tedious having to do that all the time. I was hoping there would be an automated way of doing what I need the formulas to do in each sheet.

 

[chew]

Clarification from previous post.

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.