Hi guys,
I've been wondering around the forums for a while now and although I've figured out how to add a timestamp to my workbook if data is present inside a cell using this code:
I cannot work out how to make this apply to multiple columns? For example what I need it to do is apply to both column A and column B
So that if column A has an entry then column C will have its date entered and likewise if column B has data then C will update but if one of A or B has data entered then nothing should happen. Does that make sense?
if both are blank C should be blank but if one has data the current date is entered into C but if C already has a value because A has data then entering Data into B should not effect C.
Any help is appreciated as I have been trying to puzzle this out for some time now.
Bookmarks