I have a user who asked the following - if anyone has any advice how to accomplish this, I would apprecaite it:
The user has a column (lets call it column A), with pricing information. The user would like the date or/and time "stamped" in the adjacent cell when the price changes in the corresponding cell in column A. So, hypothetically, if cell A1 has a price of $69.95 and then is changed to $79.95, he would like cell B1 to be stamped with the date and time that cell A1 was changed. And if changed in the future from $79.95 to $84.95 the cell in B1 should be stamped with that date / time - with no history needed as to previous dates / times from prior changes needed.
I suspect that this will require a VBA script, but not sure how to go about it.
The user has a column (lets call it column A), with pricing information. The user would like the date or/and time "stamped" in the adjacent cell when the price changes in the corresponding cell in column A. So, hypothetically, if cell A1 has a price of $69.95 and then is changed to $79.95, he would like cell B1 to be stamped with the date and time that cell A1 was changed. And if changed in the future from $79.95 to $84.95 the cell in B1 should be stamped with that date / time - with no history needed as to previous dates / times from prior changes needed.
I suspect that this will require a VBA script, but not sure how to go about it.
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red][/red]![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]