tracking changes

Hi

I am new to VBA and have been searching through a lot of threads but struggling to find what I need.

I have in column B numeric values (in every other row ie in B2 B4 B6 etc)

When the numeric value is changed in any of these cells i want to old value to appear in the same row.....

for example when [B]2 is changed from 2 to a 1 i then want the number 2 to appear in cell C2 . when [B]2 is changed from 1 to a 4 i then want 1 to appear in cell D2....and so on

is this easy enough to do?

any help would be much appreciated

Yeah that's doable.

You'll need to use another column to store the value in as a temp memory, but if you make the font the same colour as the cell background (eg white) then users wont see it.

Access the worksheet change event by right clicking on the sheet tab and selecting 'view code'.

In there put:

Please Login or Register  to view this content.

ok release the example layout was changed

let me try and explain

row 1 is the title row and will remain the same

columns A to D will have data manually inputted by the user
rows 2,4,6,8,and so on will have dates that show the date of when a value has changed and what the value was underneath it

so for example the user in cell D3 changes the value from 5 to 7 then the value 5 will be stored in E3 and the date it was changed will be in E2.

then the user sometime later changes the value in D3 to 10 (from 7) then the number 7 will be stored in F3 and the date it happened in F2 and then when the user changes D3 then changes will be stored in 3 and so on.

this will apply to cells D3, D5, D7 etc (not sure the limit but will apply to the odd rows)

does this make it any clearer what i am trying to do lol

hey

the second post worked. i just wanted to see if i could store an old value....if i could do that then i thought i could build on it for what i actually need.


i am unable to post the file. is there a way to amend the code in the second post so the date is added in the cell above the old value to indicate when it was changed.

thanks for all your help