transfering cell values

P

Pat

My worksheet has a value in cells B2, C2& D2. When I
change the value in B2, I would like C2 to take on the
value of B2 before it was changed and likewise D2 should
take on the value of C2. I would greatly appreciate
assistance with this formula.
 
F

Frank Kabel

Hi
this could not be done with formulas. Only with VBA (using an event
procedure). Is this a feasible way for you?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Avoiding auxiliary cells 0
Copying formulas across columns 2
Sumproduct formula problem 5
Formatting a spreadsheet to calculate difference in dates etc. 2
how to copy and paste value from one sheet to another 4
Conditional sum, when condition has multiple values 3
Help with calculating time and a half - I've got straight time and double time. 4
countifs Function not giving desired result with date criteria 2

Top