Macro: Insert formula for each row of data
I have a variable sized data set in a work sheet. Simplified it's like this:
A B
1 data1 =Today()
2 data2 =Today()
3 data3 =Today()
(Column A lists rows of data, Column B I want to insert today's date for each row)
I have a series of macros that reformat the worksheet dataset and I want to tack on the "Today's Date" formula for each record without going past the lastrow (of column A). The number of rows varies each time I import the record set. What I'm doing now is copying the formula (from Row 1) and pasting itinto a number of records I know exceeds the total of record rows imported. I then go back and delete those extra rows. (I do this for several other columns with different functions).
I know there is a better way.
Thanks.
Jeff
__________________
jm
Last edited by Jeff Monroe : August 18th, 2011 at 05:07 AM.
|