Split Excel Sheet in Multiple Workbooks

[united2017]

Hi All,

I have a data file consisting of 8 columns (around 50K rows) and I want to split this into multiple workbooks.

Column 5 - has the supplier number and the data in the file is sorted by this supplier number - I want to create separate workbooks for each supplier - and the File to be named the Supplier Number.

 

[bebo021999]

What 'd you like for new worksbooks, i.e, "User1.xlsx", blank WB or with correspoding data of that user (8 columns * rows of User1)?

 

[united2017]

What 'd you like for new worksbooks, i.e, "User1.xlsx", blank WB or with correspoding data of that user (8 columns * rows of User1)?

Product Code	Product Description	Product Current Cost Excluding GST	Supplier Product Code	Supplier	Product Group	Product Price Code	Product Category
03617591	Tool Kit		03617591	000001	TOOLS	815	TOOLS
049054012	WASHER-NYLON .25 X.50 X		049054012	000001	CONSUM	196	CONSUM
1113388	RUBBER INSERT GASKET 1PLY 1000X300X3.0MM		RIV1113388	000001	CONSUM	217	CONSUM
12MM EYELET	12 MM EYElets 20 pk		ZZ12MM EYELET	000001	CONSUM	212	CONSUM
12MM PUNCH	12 MM PUNCH PLIER EYLET DELUX		ZZ12MM PUNCH	000001	TOOLS	818	TOOLS
135913	1-5/8 X 1" DRV DP SOCKET		RIV135913	000001	TOOLS	811	TOOLS
136846	POLISHER/SANDER M12 KIT MILWAUKEE		RIV136846	000001	TOOLS	807	TOOLS
142453	1-1/2" 1" DRV SOCKET		RIV142453	000001	TOOLS	811	TOOLS
1TEK12-14X45	12-14X45 SDM CL4 HEX TEKS		1TEK12-14X45	000001	CONSUM	197	CONSUM
300BE1060	150MM SLIM TAPER FILE		RIV300BE1060	000002	TOOLS	818	TOOLS
3520-10.00K	PowerCoil Thread Kit M10x1.5		3520-10.00K	000002	CONSUM	213	CONSUM
3520-12.00K	PowerCoil Thread Kit M12x1.75		3520-12.00K	000002	CONSUM	213	CONSUM
3520-14.00K	PowerCoil Thread Kit M14x2		3520-14.00K	000002	CONSUM	213	CONSUM
3520-16.00K	PowerCoil Thread Kit M16x2		3520-16.00K	000002	CONSUM	213	CONSUM
3MAC019444218	3M SILVER COW 125MM CUTTING DISC BUCKET		RIV3MAC019444218	000003	CONSUM	203	CONSUM
400GZINC/GALV	Spray Paint Zinc Galv Grey 400gm		ZZ400GZINC/GALV	000003	CONSUM	199	CONSUM
42015	LATCH		RIV42015	000003	CONSUM	218	CONSUM
5SHPH	POST HOLE SHOVEL W/ LONG HARDWOOD HANDLE		RIV5SHPH	000003	WRKSHP	873	WRKSHP
6785826012	PROTECTOR RR DOOR		ZZ6785826012	000003	LIGVEH	528	LIGVEH
6830426110	RAIL SUB-ASSY SLIDE		ZZ6830426110	000003	LIGVEH	528	LIGVEH
70127	15M EXTENSN CORD 15AMP PLUG & PIN ORANGE		RIV70127	000003	WRKSHP	874	WRKSHP
74060	60MM Slogging Wrench Flat		ZZ74060	000003	TOOLS	816	TOOLS

 

[united2017]

At each change in the supplier code, I want a new workbook created with the data for that supplier - and dropped in the same folder as the main master file - named - "Supplier Code.xlsx"

 

[Michigander]

At each change in the supplier code, I want a new workbook created with the data for that supplier - and dropped in the same folder as the main master file - named - "Supplier Code.xlsx"

Did you ever get a solution to make this work? I'm also trying to split up a workbook in a similar way.