Need macro to copy cells into sheets that are automatically generated from list

Hi Everyone,

I have a sheet in a workbook with a list of machine part numbers and their corresponding measurements. I have a macro that can create a new sheets and name them based on the part number in the list. I have an additional sheet that is an inspection form sheet (with formatted cells) that I would like pasted into each new sheet that is being created for each part. Is there some additional code I can add to my current code that would allow the macro to copy the formatted cells on the inspection form sheet into each new sheet that is being generated from the list?


Here is what I am using to generate the new sheets:

Please Login or Register  to view this content.

Yes, but we need the details of the inspection form sheet to see the range of cells used, and where want to put it in the part sheet. Ideally you would attach the file.

In general the idea would be

Please Login or Register  to view this content.

where A1:X99 is the range of cells you want to copy from the form, and AA1 is the destination where it goes in the new form.