Adding a step to a macro

[mdt175]

Hey guys,

I am fairly new so bare with me. I have attached a report I have been working on for a few weeks. Now that the macro has been built on all of the pages under the same name "Update," I would like to add a step to the macro. The step is copying and pasting B8:B19-AF8:AF19 to the tab "LW." Anyone know a good way to add this step to my already-recorded macro rather than re-recording everything?

Workbook added for reference. Thanks for your help - I appreciate the time.

-Mitch
Denver,CO

[Vidya Palani]

Paste this towards the end of your macro just before End sub.

Please Login or Register  to view this content.

[mdt175]

Thanks, Vidya. If this would be for each month - how would I add each name to the Sheets("Oct 14").Select portion?

[daveb86]

Wouldn't you need Column A as well so you know what each of the rows are ?

A8:A19 - AF8:AF19

Dave

[mdt175]

Ok I answered my own question. If you take out the line that says the name of the tab - it will go to each page. Problem Solved - t hanks fellas