Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO's
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro's are fun | Excel Worksheet Functions | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
Macro's | Excel Worksheet Functions | |||
Macro's | Excel Discussion (Misc queries) | |||
macro's | Excel Worksheet Functions |