Ok I have a a list of about 392 items that needs to be put into an excel form. I manage to get Column A (which is the inserted worksheet names) to name the worksheets that is automatically inserted.
I have attached an example of my table
When the code names names the see it also puts that same name in cell "N8"
From the table I also need for the code to put in the information from that same line to insert various cells from the table. When you look at the attachment the columns that is highlighted in row 2.
The code is in MODULE 2 of the attached file.
Let me know if you need anything else.