Splitting Multiple Tabs into one workbook based on column in each tab

**charley94xx** · 08-20-2019, 04:56 AM

Hi All,

Hoping you can help

I am trying to get a workbook that has multiple tabs split into based on a column into a workbook.

I am able to do it for one tab but i need all the tabs in the workbook spit based on a name saved into on workbook so it just shows all information for that person but has all the tabs still.

Sorry if that sound confusing. Hope you can help

**PaulM100** · 08-20-2019, 05:01 AM

Hi and welcome to the forum. Please upload a sample data with mock up results. To do so, go advanced, manage attachments the rest is straightforward

**charley94xx** · 08-20-2019, 05:32 AM

Thank you

I have now attached sample data, Each tab has different information on but would like the file split based on the team leader name.

So each tab will only have the information for that team leader.

Splitting Multiple Tabs into one workbook based on column in each tab

LinkBack

Thread Tools

Rate This Thread

Display

Splitting Multiple Tabs into one workbook based on column in each tab

Re: Splitting Multiple Tabs into one workbook based on column in each tab

Re: Splitting Multiple Tabs into one workbook based on column in each tab

Thread Information

Users Browsing this Thread

Similar Threads

Splitting one worksheet into multiple sheets within the same workbook based on row number

splitting multiple worksheet based on column criteria

[SOLVED] splitting data into multiple tabs based on column criteria

[SOLVED] splitting data into multiple tabs based on column criteria

Maintaining data validation+formulas after splitting workbook based on column

[SOLVED] Help: Splitting large workbook into separate workbooks based on R column value.

Splitting column of numbers into multiple columns moving to new column based on value

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions