Posts by KAT11220

    Re: SaveAs Multiple Worksheets into Multiple Workbooks


    gijsmo,

    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?

    Thanks!

    Re: SaveAs Multiple Worksheets into Multiple Workbooks


    Hi gijsmo, thank you for writing this code. If possible, I want to save these new workbooks with the name "100", "200" etc..."commission month"

    Also, as I am testing the marco, I notice there are a few more sheets I need to copy over as well in order for the calculation to work. Here is a list of tabs I need to bring over..
    "Data"
    "Input"
    "Assumptions"
    "AE Flu Tracings"

    These tabs need to be hidden too.

    Thanks!

    I have a workbook of 50+ worksheets. The worksheet names are 100, 101, 102 ... 199, 200, 201... 299 etc...and "Data". I need to group and SaveAs all "100", "200", etc worksheets along with the Data tab (to calculate all the formulas) as individual workbooks.

    I have been searching and tried many methods, but nothing has work. Could someone please advise this is possible?