Run 2 Macros one after the other.

[Keibri]

I have 2 Macros which are run one after the other. I would like to ask whether it is possible to adjust the following two codes so as to make them function more smoothly. This is how the macros function.



The first macro, Macro 1, copies some cells from the active workbook (“Workbook 1) and then it opens another workbook, “Workbook 2”, and pastes the cells there. Once pasted the macro, saves “WorkBook 2” and closes it. Once closed a popup in the previous workbook, i.e. “Workbook 1” shows a pop up message box stating: "Data Successfully Archived". This macro can be found below:

Please Login or Register  to view this content.

The second macro. Opens “Workbook 2” (the same workbook 2 as above) performs an advanced filtering of the data, saves and closes “Workbook 2”. The Macro is found below:

Please Login or Register  to view this content.

What I had in mind was whether is it possible to smooth the process since currently: Workbook 2 is opened to run macro 1, saves and closes. Then it opens again, performs an advanced filtering, saves and closes.

Would it be possible to join the two macros?

If not, would it be possible to ensure that Workbook 2 is opened just once?

Thanks a lot for your help and insightful suggestions

[Bernie Deitrick]

Sure - try it like this. (It wasn't clear which sheet you want to filter - I thought it was Sheet2, but maybe not, so change it where indicated)

Please Login or Register  to view this content.

[JOHN H. DAVIS]

FWIW:

Please Login or Register  to view this content.

[Keibri]

Thanks a lot everyone! It worked wonders!! Cheers