Alteration needed: Sort sheets with cell value

Hi Guys,

Below code is good, however i would like it to only copy sheets with a specific value in a cell. So for instants if there is the word "Yes" in a cell then copy that sheet. so if i have 32 sheets and only 4 of then contain the word "Yes" in cell "A1" then those 4 sheets get put into a new workbook and saved to a path. Could someone please advise.

Thanks,

Alan

Please Login or Register  to view this content.

Change of Title to Match need.