shifting values


C

ChinaBoat

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
 
Ad

Advertisements

S

swatsp0p

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?
 
Ad

Advertisements

C

ChinaBoat

Well, duh...

Sometimes one forgets to kiss and starts looking for an "elegant
solution - thanks much for the answer and reality check <grin
 

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

shift 0
Shift Objects 2
Shift information 2
range shift 1
Shifting Objects 2
Evaluating Work Shifts 5
Excel Shift Roster 9
cell heights shift 1

Top