VBA code to save selected sheets to a new workbook

[JonasTiger]

Hi
I found this thread
vba code to save selected sheets as new file
That works fine and fast to create a new WB from selected sheets in an existing WB

The changes I need to do is:

• available to choose the sheets (not the the last 3 that the code fits) - I need to select 6 random sheets (i.e, "Sheet1", "abb", "Sheet4", ...)
• not display zeros in allsheets in the new WB
• Filter all sheets in the new WB, based on values of a specific column

Thanks in advance
JT

 

[John_w]

The code works fine and quick, but...
Still the sheet "PLAN" - colors don't show up in cells like the original, cells still remain all white. is it possible to make that correction?

I've looked at your sample workbook. The conditional formatting formulas in the PLAN sheet reference cells in the REGCAD sheet, so if you don't copy the latter the conditional formatting formulas will have nothing to use.

 

[mumps]

@John_w
Thanks for that. I missed the conditional formatting!!!!