cchris_uk
02-20-2008, 10:09 AM
Hi,
I need a function that can be placed in cells in a column that:
Checks the cell in 'A' column on the current row for a valid date.
If no date exists, check a range of cells on the current row (eg B, C, D, E)
If the selected range contains data, then enter the current date in column A else do nothing.
At no time should a date be overwritten, it should only be inserted if it did not exist in the first place and the selected range contains data.
If this can be created as a function, then that would be great, as I cannot rely on the users of this sheet to remember to run a macro each time they enter data and I need the spreadsheet to keep a record of the date data is entered for each row.
Regards,
Chris
I need a function that can be placed in cells in a column that:
Checks the cell in 'A' column on the current row for a valid date.
If no date exists, check a range of cells on the current row (eg B, C, D, E)
If the selected range contains data, then enter the current date in column A else do nothing.
At no time should a date be overwritten, it should only be inserted if it did not exist in the first place and the selected range contains data.
If this can be created as a function, then that would be great, as I cannot rely on the users of this sheet to remember to run a macro each time they enter data and I need the spreadsheet to keep a record of the date data is entered for each row.
Regards,
Chris