there will be running entries in 10 or so columns with each entry using only one row. I need to lock column A and B only in a row that information has been entered. the sheet will continue to populate for several rows, maybe once a month it will be saved and restarted. There could end up being a couple of hundred rows used. I have a "NOW" function to record when the info is entered in each row, but the date and time currently updates, in all rows, any time info is added to any row of sheet, this is what I want to avoid. I want to hold the date and time in each row without locking the unused portion of the sheet.
|