Split worksheet

[Luphai]

Good Day

I am new and asking assistance with a macro that would copy workbook content into
diferent worksheets on the same workbook. The column that is to be used to filter is column
F11 which is the salesrep column.

Thanks in advance

[AB33]

Please Login or Register  to view this content.

[jraj1106]

Hi Luphai

You have not specified about the data to be copied. Please explain what you wish to copy to different worksheets in the same workbook.

[Luphai]

I would like to copy contents the Salesrep column with corespending rows to new worksheet

[AB33]

Have you tried my code?

[Luphai]

AB33

Just did but I see its adding two blank sheets as well either than
that its working fine.

[AB33]

Luphai,
The two existing sheets have already been there, they are not created by the code. If you want to test it,delete these two sheets, or all sheets for that matter (except sheets 1) and re-run the code and you will see not blank sheets.

[Luphai]

Thanks AB33 code working like a bomb

[AB33]

Luphai,
You are welcome!
Could you please now close this thread as solved. Go to the top-right-hand of this page-choose "Thread Tools" select solved from the drop down menu?

[Luphai]

Hi AB33 when i run the following amended code on the intended spreadsheet it deletes the content of the Data sheet
and copies only one rep. Please note changed spread sheet

Please Login or Register  to view this content.

[AB33]

Luphai,
Please use code tags as per forum's rule. Edit the above post. Highlight your code and click the icon # while I look at your request.

[Luphai]

Done sorry

[AB33]

The reason why all the tabs have not been created is that you have / in rows 22-31 (Column P). VBA would not allow you to create names using a slash, so when the code reaches these rows it creates blank sheets.

Please Login or Register  to view this content.

[Luphai]

Thanks AB33

[AB33]

Luphai,
I have tested the code by changing the names in rows 22-31 and the code has created tabs for each changed names, no blank sheets. In fact, you have lots of characters on names which are not permitted by VBA. I would advice you to change the names of these items. Please close this thread.