Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Stamp in one cell when data in other range changes
Hi,
I tried to figure out how to make the code that JE McGimpsey has posted on his site: http://www.mcgimpsey.com/excel/timestamp.html "DateStampMacro" but just do not have the VBA skills to decipher how I need to change it to work for me. I'm trying to have a date time stamp in cell "D1" whenever my user changes data in either of two ranges "C18:V32" and "C37:D43". This is a customer tool for pricing and I want to record the date that they changed inputs that affect price. This is xl2003 These ranges have all kinds of data validation rules that are generated from sheets that are protected and this workbook and worksheet will also be protected to keep the user from overrighting formulas etc. Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date stamp when a value is entered in a cell | Excel Worksheet Functions | |||
Date stamp when a value is entered in a cell on another worksheet | Excel Worksheet Functions | |||
Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
How do I set an automatic date stamp into a cell in Excel? | Excel Worksheet Functions | |||
Setting up a date and time stamp in a cell | Excel Programming |