Need help with Excel/VBA

Hello,

I have a list like this:



I want to create a .xls file for each of the IDs/rows. I also need the information in the XYZ columns to be copied over to the new file (in specific cells, e.g. cell A1, C3, C4).

I guess this can be easily done with VBA, but I have no knowledge of it. And I don't have the time atm to learn it. Could anyone direct me to a site where I could find scripts dealing with this problem? Or maybe one of you can write it in 5 minutes??

Is the list currently in a text file? You could probably just open it in excel and if would put it in the cells for you. Otherwise I could write the vba quickly... But depends on the source data format.

The list is in excel. I've figured out a way to collect the data from the list into another spreadsheet, however it requires me to manually save the file with correct filename. And when the list has several hundred entries, I really want to skip those manual operations for each file.

If you have the time to write the vba, I would greatly appreciate it.

Email it to me: cfcgotm[at]gmail.com, along with detailed instructions of what you want.