• 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 and save it with name onto different workbook

Status
Not open for further replies.

uday

Member
Hi,

I want to split data and save it with supervisor name in folder.

Now there are two tables Black and Yellow. If the supervisor name is not present in Black, but exists in Yellow then also it should create different workbook and vice versa.

I have given the Main macro template and output file.

The loop process should continue till last supervisor name for each and every table -
Black and Yellow. I was facing problem to copy the data from Data sheet and the reason being I have created new sheet as Data1 then used the same sheet as table two data.

*Issue - when I am trying the to save the table two data from data1 sheet, it is not allowing me to create workbook as New.xlsx.

Thanks & Regards
Uday


▬▬▬▬▬▬▬▬▬ Mod edit : thread closed as duplicate !
 

Attachments

  • Split-data-into-separate-workbooks(AutoRecovered).xlsb
    32.8 KB · Views: 0
  • Supervisor-1.xlsx
    8.9 KB · Views: 0
Status
Not open for further replies.
Back
Top