Automatically create files or worksheets

[Teaman]

I am wondering if it is possible to write a program or macro for excel to be able to take cells under specific headings in an excel spreadsheet and create either separate files with the name of the first heading or worksheets with the name of the first heading and populate certain fields in files or worksheets.

An explanation: I have a spreadsheet with 16 columns. The rows of the spreadsheet have specific information for several pieces of equipment that fall under the headings of the 16 columns. I also have to create separate spreadsheets for each row in the spreadsheet that format the data differently so it can be embedded into an autocad file. I could use worksheets in the same spreadsheet for this instead of separate excel files. What I would like to do is be able to automatically create the separate files or worksheets from the one master spreadsheet with all the information in it. Row 1 goes to File 1, Row 2 goes to File 2 and so on.

Does anyone know how to accomplish something like this?

Thanks
TeaMan

[karan]

Hi Teaman,

Can you attach the file? Make sure you remove all the sensitive data.

--Karan--

[Teaman]

I've attached two spreadsheets. The large one is with all the data for one piece of equipment. I have about 120 of these to do. Column B contains the names of the components of the equipment and this is the name I need for my file and also in the equipment block of the second sheet. The second file is the one that is placed on the drawing.

Please ask for any more clarification.

TeaMan