Macro logistics - Most efficient place to put macro, help

[rlc]

I have a report that is required to be ran twice a month with multiple steps required. My question is have to:

1. Run the report
2. Add the report to an existing tab for reference.
3. Complete multiple steps which require
a. Filtering
b. Deleting rows
c. Insertion of columns
d. vlookup

I am not sure I can ackomplish all things through the macro, but enough to speed up the process. I cant attach the macro to the sheet, because it would change each time. Thanks for any assistance you can provide.

Thanks,

 

[ranman256]

Yes macro will work.
Hit the RECORD button (to personal workbook), then do all the steps, stop recording.
Then edit the macro to fit your needs:
change hardcoded names like the imported filename, change the filename to a variable , or user pick so it can be customized.
etc.

 

[AlphaFrog]

Copy your macros to a Personal Macro Workbook

 

[rlc]

Thanks,

Will give it a try.