Need "Last Updated" entry for pricing

Posted by Jayson Tomlin on June 18, 2001 1:09 PM

I would like the ability to track when my pricing was last updated. If today I changed the price, I would like the last updated field to automatically switch to todays date. Any ideas?

Please respond via email in addition to the forum.

Thanks,

Jayson

Posted by Damon Ostrander on June 18, 2001 1:38 PM

Hi Jayson,

I recommend you use the VBA Worksheet Change event for this. This event allows you to determine which cell (the Target argument) was updated, so you can check and if this cell is a pricing cell, you can then stick today's date in the last updated cell. This ensures that the date is updated only when the price changes.

Damon