How is it possible based upon one file;
Column A Name (lots of different names)
Column B Price
Column C Part
Column D etc.

Based upon above file - split this into different saved file with column A
as the key splitting the file with the name in column A as file name. Meaning
one name (column A) one file.