View Single Post
  #3  
Old August 23rd, 2011, 12:52 AM
Jeff Monroe Jeff Monroe is offline
Member
 
First recorded activity by OfficeFrustration: May 2006
Location: San Diego, CA
Posts: 27
Default

Quote:
Originally Posted by tarquinious View Post
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.
__________________
jm