Quote:
Originally Posted by tarquinious
You could use something like:
Code:
=IF(A2="","",TODAY())
In this way it doesn't matter if you paste it further than the data you have, nothing will appear if there is no data in the cell.
|
Tarquinos:
That formula works. The only problem is there is now information in those cells. Because of that, those rows are included in any sorts I do (unless I filter out the blanks). This actually pushes some of my filled rows down to the last rows of 2000 (text comes after blanks). I would like to figure out how to do a loop based on how many records I have.
Thanks.