VBA to save tabs as individual workbooks by tab's name

Hello,

Every month I have to submit a report. It usually takes the whole day because there are a lot of repetitive tasks that come with preparing the report. I need is to save some of the tabs in the attached spreadsheet as their own workbook. I do not know where to even start with VBA for saving in excel.

I would like for the new workbook to be saved as the title of the tab and into the same folder as the original file. Also, some of the tabs do not need to be saved. In the sample attachment, only tabs "20700", "40002", "10100" and "30300" need to be saved.

Hi
You query is really confusing...... can you explain in detail...

Originally Posted by naveenmarapaka

Hi
You query is really confusing...... can you explain in detail...

Hello,

The query returns all of the information in one tab. I used VBA to separate it into one tab per business unit. Now I need to add something to the VBA to save each tab to a new workbook. The file should be saved as the tab's name.

Originally Posted by Norie

There's no code in the attached workbook.

I think if we could see that code we could advise on how it could be altered so that data is put in new workbooks instead of separate tabs.

Norie,

Please kep in minda that I have removed 2 columns from the spread sheet I provided. That is why vcol = 3 and title = "A1:F1" instead of vcol = 2 and title = "A1:D1"

Thank you, Norie. I have corrected my post. I apologize. This is my first post.