Auto Fill formula with growing data

I have the following formula

Please Login or Register  to view this content.

And I need to auto fill my workbook

Please Login or Register  to view this content.

Is there a way for me to tell my macro what my ending row is? Instead of me putting row number 165882. I have a text file that I import all of my data from. This file is growing all the time and I need to be able to tell my macro to go to the end of the line. Just a example on 5-11-10 the last row was 165882 now it is 175238. So if I run my existing Macro it does not populate out the formulas to the new data. I hope I am explaining what I need to do. Thanks for any help!

I use a lastrow variable to test a specific column for the last row of data, usually column A, but you can adjust that. Then I use that variable to set the range used in the other columns.

Please Login or Register  to view this content.

NOTE: You should get into the habit of editing out the selecting in your macros. You see that in recorded code because it records what you did, but you don't have to select a cell then refer to it as "Selection" or "Activecell" in VBA, you can issue your commands directly to the cells themselves without selecting.