I have 100+ rows each with 6 cells (A-F) A & B contain variables which may or may not change daily and C-F have values produced as follows: C=A*B, D equals what was previously in C, E=what was in D, F=what was in E, what was previously in F doesn't matter.
Can a formula be written to shift the values from one cell to the next or does this have to be done manually everytime a variable changes?
Thanks for your help.
CB
If I understand your situation, here's what you are trying to do:
When either A or B (or both) are about to change, copy the value in E to F, D to E, and C to D then calculate a new C based on the new values in A &/or B.
If this is correct, you could create a macro to copy C:E and paste them in D:F; then enter your new A B values.
Would this work for you?
Bruce
The older I get, the better I used to be.
USA
Well, duh...
Sometimes one forgets to kiss and starts looking for an "elegant" solution - thanks much for the answer and reality check <grin>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks