Timestamp in Excel 2003
Posted on 2011-02-15
Experts - I need your advice?
I have a timestamp problem. This formula:
=IF(A1<>"",IF(B1="Date/Time Stamp",NOW(),B1),"Date/Time Stamp")
works for me. However, the formula must be populated throughtout column B to accomodate scan data entered into column A. With worksheets added for each day and hundreds of lines used in each worksheet, I reach Excel 2003 size restrictions.
Can I create or move the formula in column B down one row as I go? Can I do this with a formula instead of a macro?
Gary - Cincinnati