As ALWAYS, post your code and details for comments and suggestions.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"arangoa79" wrote in message
...
I work with imported data that varies in size. In order to prepare the
data
for analysis I take the same repetitive steps. I know using a macro would
make it simpler. I have a question regarding the macro as I record it. I
always copy a vlookup formula down a column to the last row containing
data.
If when recording I stop at line 300 is that where the macro will stop
every
time I run it? The amount of data I work with changes in size every week.
If the current data source has lets say 400 lines will the macro stop at
300,
which is where it stopped when I recorded it? If so how can I ensure it
goes
all the way to the last line?

In this same scenario, once the vlookup is done I copy that same column
and
past special values. I then sort by that column in order to isolate the
#N/A. I then apply a different vlookup to all the rows after the first
#N/A.
How does the macro know to start at a different row then when it was
recorded. Since the data will change after sorting the first #N/A will
most
likely start in a different row.

Not sure if all this makes, maybe I need to consult with a excel wiz but I
would like to solve this without asking for help from my peers. Thanks