Split data into separate file and save according to filename

[pesteness]

Hi Pesteness,

Welcome to ExcelFox!!

Download the workbook from here:

http://www.excelfox.com/forum/f12/sp...les-33/#post81

Hi Admin,

Thanks for the reply, however the title should not be replaced with title1,2,3 etc. as well as the picture and part number , i need the data on it, look at the "SensorExhaustOxygenPFOS730.xlsx" the output should supposed to be like that, i have provided a filename that you can use on the filename column, the program will split the data for part number.

example part number:PFOS730
the program will filter all the "PFOS730" in workbook, as you can see in the file.xlsx there so many "PFOS730" i want to filter all and split to a new workbook

l
Again, Thank you.