Split data into separate file and save according to filename

[pesteness]

Hi

Sorry for the confusion. That's only dummy data. You have to replace those data with your actual data.

its okay,

yes, i already did that but still the macro just grab a single data, for example this part number "PFOS786" has some duplicate in the my DATA but it has different title, what i wanted to happen is gather all the data within this part number "PFOS786" in one workbook, like below sample, and use the file name in the filename section so for this part number the file name should be "SensorExhaustOxygenPFOS786"


Part # title etc etc etc....
PFOS786 Alfa Romeo 75 Twin Spark 4 Cyl 2.0L Exhaust Oxygen Sensor
PFOS786 Alfa Romeo 75 V6 Cyl 3.0L Exhaust Oxygen Sensor
PFOS786 Alfa Romeo 164 V6 Cyl 3.0L Exhaust Oxygen Sensor
PFOS786 Audi 80 Quattro 4 Cyl 1.8L Exhaust Oxygen Sensor
PFOS786 Audi 90 Sport Quattro 5 Cyl 2.3L Exhaust Oxygen Sensor
PFOS786 Audi 200 Turbo 5 Cyl 2.2L Exhaust Oxygen Sensor
PFOS786 Audi Quattro V8 Cyl 3.6L Exhaust Oxygen Sensor
PFOS786 Audi S4 Turbo 5 Cyl 2.2L Exhaust Oxygen Sensor
PFOS786 Jaguar Sovereign 6 Cyl 3.6L Exhaust Oxygen Sensor
PFOS786 Jaguar XJS Sport 6 Cyl 4.0L Exhaust Oxygen Sensor
PFOS786 Jaguar XJS V12 Cyl 6.0L Exhaust Oxygen Sensor
PFOS786 Saab 9000 4 Cyl 2.0L Exhaust Oxygen Sensor
PFOS786 Volvo 240 4 Cyl Exhaust Oxygen Sensor
PFOS786 Volvo 740 Turbo 4 Cyl Exhaust Oxygen Sensor
PFOS786 Volvo 740 4 Cyl Exhaust Oxygen Sensor
PFOS786 Volvo 760 Turbo 4 Cyl Exhaust Oxygen Sensor

Thanks and God Bless.