Re: SaveAs Multiple Worksheets into Multiple Workbooks
I think we are almost there!!! My only issue is that because every sheet is copy individually, the formula is referencing the master workbook and not the new "data" tabs copied. Is there a way to copy the group of worksheets together? Or a code to reference to the new workbooks?