Need Date Stamp when any cell in that row changes

Hi,

I need to create a date stamp for each time a record (row) is updated and address certain conditions that may exist in that row. I searched for an already posted solution but didn’t see this specific scenario.

I have several spreadsheets in a workbook where each row is a record and each column is a variable about that record (sample attached). Some columns will be dates, some will be numbers and some will be text. Some will be generated from data validated lists and some will be hand entered. Some columns may not have any data entered at the time a change is being made.

Each time someone enters new information or changes existing information in that row, I would like to populate the last data entry column that row with a date stamp (hours/minutes not required, prefered format is MM/DD/YY). This should happen even when someone changes data based on a drop down list or when a previously blank cell now has an entry.

This solution will need to work for multiple spreadsheets with different numbers of columns, sometimes the date stamp may appear in column F, sometimes in Column K so I need to be able to adjust it. For this reason I’m hoping that this could be achieved through functions and not VBA script.

Thanks,
Peter

Originally Posted by Fotis1991

Hi Peter.

See if this can helps you.

http://www.mcgimpsey.com/excel/timestamp.html

Thanks Fotis. As I look at the code (the formula doesn't seem to work for a range of cells) I think it could do what I need but I'm all thumbs with inserting VB code.

How do I embed the code into my workbook/worksheet - I want to call up this code for multiple worksheets in different columns?

How do I reference the specific column or cells where I want the date stamp to appear?