Splitting a column data into separate tabs.

[DataPirate26]

Hello, 

I want to split the data of a particular Input sheet having a collated data to separate tabs and further to separate workbooks based on a particular column "COMPANY" . 

So each Tabs will be having specifically the data for that particular company and then also should create a separate excel workbook with the company name. For example (Chemical org.xlsx, LMX.xlsx etc) as attached below. 

The first 2 rows will be blank in each tabs and the service subtotal and associate subtotal will be displaying the summarize total leaving one row as given. 

1.The Input test File has the given collated input data sheet and also the tabs how it will look after splitting. 

2. The chemical.org xlsx file is an example how the separate workbooks with that company name shall come up. 

Can someone assist me to get the desired result. 

[gabrielvilella]

Where is the file extension there? You need somthing like Folder\File.xlsx|||Sheet$A1:C

[DataPirate26]

@gabrielvilella Yes. I need to write the output in a specific range. But it is giving me an error "invalid sheet range or specification in excel"

[DataPirate26]

@gabrielvilella Is it possible to get the same output like separate tabs and separate Files as you have provided the solution above , But i need to apply formatting on all the tabs and the files. . So would need to use the render tool instead of the Output tool. Can you give a solution to this ?

[gabrielvilella]

You can overwrite formatting with the output tool, you just need to follow the structure I mentioned for the file name.