• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Split Data into new workbook

uday

Member
Hi,

I want to split data into new workbook with item selected in filter.

Now it is working fine with given table which is black. I want to also add the data which belong to title highlighted with yellow into same new workbook just two rows down from first data.

It can be possible Table 1 highlighted with black criteria not present in Table 2 highlighted with yellow, however it needs to be also create new workbook with same criteria name.

In simple word - Any new supervisor name may not be included in Col. B but present in Col. H then needs to create new workbook for new entry or criteria or supervisor type and save as accordingly.

Thanks
Roy
 

Attachments

  • Split-data-into-separate-workbooks.xlsb
    19.5 KB · Views: 5
Hi,

Please see the updated Macro File.

Now I am getting error while trying to create new workbook. I have given the output file as well.

Thanks
Uday
 

Attachments

  • Split-data-into-separate-workbooks(AutoRecovered).xlsb
    32.8 KB · Views: 9
  • Supervisor-1.xlsx
    8.9 KB · Views: 3
Back
Top