Changing Values of Multiple spreadsheets!??!

[clarefreight]

Hello everyone. Let me start off with the fact that I really don't know much about Excel. It's a foreign language to me and I have a lot of respect for those of you that have mastered it.

My question concerns formulas that change cells on multiple spreadsheets in the same workbook. I hope I'm using the right terminology.

Example:

I have 2 spreadsheets. "SheetA" & "SheetB".

"SheetA" - cell A1 has the value of $2.15
"SheetB" - cell A1 has the value of $2.25

I want to be able to add $.05 to "SheetA" cell A1 and have it add the $.05 to "SheetB" cell A1. In exchange, the cells should now read:

"SheetA" - cell A1 has the value of $2.20
"SheetB" - cell A1 has the value of $2.30

I am assuming this is something quite easy, but as I mentioned above - this is all a foreign language to me.

I would appreciate any help anyone can offer.
Many thanks in advance,
Tony

 

[chicagodiceman]

Welcome to the board.

Is sheet B value always $0.10 more than sheet A value? If so, just enter =SheetA!a1+.1 in A1 on SheetB.

When you change the value of SheetA, it will automatically update sheetB.

If this isn't what you're looking for or need more help, please post back.

 

[clarefreight]

Thanks a lot! This is exactaly what I was looking for!! A million thanks my friend!!