You can't do what you want to do without some VBA code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jeff" wrote in message
...
I'm going to simplify the scenario. I have 2 worksheets A & B,
Worksheet A
cell A1 has a value of 10. Worsheet B takes this value and
Cell B1 is now 10.

Now the question, I want to remove the value of 10 in Worksheet
A, but I
want the value to stay in Worksheet B.

Then to make it even worse, I want to put a new value in
worksheet A cell A1
such as 5 and have it add to Worksheet B cell B1 making it now
15, so on and
so on.

Is this possible?

Thanks