Macro logistics - Most efficient place to put macro, help

rlc

New Member
Joined
Feb 11, 2010
Messages
41
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,
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
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.
 
Upvote 0

Forum statistics

Threads
1,213,533
Messages
6,114,179
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top