Payment history record

[cg080127]

Hi

I am new to the forums and just looking for a bit of advice on a problem that I can't seem to figure out. After months of research on the internet and trying different formulas I have just about given up.

what I am trying to do is to have the total of a sum displayed in a box, then I would need another box that would show the old price after the sum has been changed.
each time the sum changes I would like it to add it to a another box next to the other to keep a record of all the old prices. this is probably quite simple to do but every time I try the value of sum changes everything.

any help would be appreciated

thanks.

[wenqq3]

Hi cg080127,
Welcome to forum. A workbook help to explain.
Please manual do a before and after sample workbook.

Post a WORKBOOK.
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[cg080127]

Thank you for the quick reply, I have attached the before and after workbooks like requested.

I am trying to get the current price to change when part cost changes but leave the old price unchanged, then move to the next box.

before.xlsxafter.xlsx

[wenqq3]

hmm, i saw the formula is equal to another cell. That mean, when column "Part Price" change, the column "Current Price" and "Old Price" change together.

let me it clear,
1. You will keep update the "Part Price".
2. Before update to "Current Price" base on "Part Price", you want keep the "Current Price" records to "Old Price".
Is my understanding correct?

[cg080127]

Yes that is what I am wanting to do.

Thanks.

[wenqq3]

Since you make the "Current Price" equal to "Part Price", therefor the "Current Price" will keep update based on "Part Price".

2. Before update to "Current Price" base on "Part Price", you want keep the "Current Price" records to "Old Price".

Then you don't wish manual copy "Current Price" and paste to "Old Price"?, it just simple ctrl+c then ctrl+v.
Are you wish auto copy "Current Price" and paste to "Old Price"? My thought is a macro will help, but it need you press the macro to run as well.

[cg080127]

I could just copy & paste but its easier to have excel do it for me as this is only an example, the full excel workbook has over 1000 entries and will get bigger over time. A macro is probably going to be the best option so I will look into this.

Thank you for your help.

[wenqq3]

Please Login or Register  to view this content.

I no sure this okie for you or not.
lastCurPrice = get the last row number of current price col.
Then copy and paste as value at col F.
You can modified the code where you Current Price and Old price located.

[cg080127]

that does exactly what i need it to, is there a way to see if col F is empty or not & if no then copy to the next cell.

Thanks.