Macro Update - Save worksheets from 2 workbooks into new file (instead of from 1 workbook)

[djro69]

Hi folks,

JBeaucaire kindly drafted me the macro below which saves worksheets from Workbook1 provided they had certain criteria in Cell G1. (Criteria being the details in column A of worksheet "Menu")

I'm currently having a slight issue with the file being very large with so many tabs and I was wondering if it would be possible to copy tabs from Workbook1 & Workbook2 (instead of having all tabs in 1 worksheet) provided they had certain criteria in Cell G1. (Criteria being the details in column A of worksheet "Menu")

Basically I'm trying to get the following:

If the tab "Menu" of Worksheet1 has a list of names = "Jim", "Mark", etc. in column A of "Menu" tab of Workbook1, the macro copies all tabs from Worksheet1 & Worksheet2 (that contain "Jim" in Cell G1) into a new Workbook, then copies all tabs from Workbook1 & Workbook2 (that contain "Mark" in Cell G1) into a new Workbook...

Many thanks for the help guys!


https://www.excelforum.com/excel-pro...-criteria.html

Please Login or Register  to view this content.

[djro69]

Thanks Ali - I couldn't figure out how to do that! Much better looking.

[djro69]

Hope that makes sense folks but please give me a steer if I'm as clear as mud (just fixed a few errors in my description)

[djro69]

Still struggling with coming to a solution on this one.. can anyone even point me to any macros that copies worksheets from 2 different workbooks?