clarefreight
New Member
- Joined
- Sep 13, 2006
- Messages
- 2
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
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