Copy list and add spaces between lines on a new tab and add formula on inserted lines

Hi Experts,

So basically, I have tab “ListofMaterials” and I write in 10 material numbers in there below the description row.

What I want is a macro to take the material numbers from that list, put one in row 2, column A, then put an H in row 2, Column G, and then put 50 D’s in column G below that H.

Then I want the second material number from that list, put that in row 53, column A, then put an H in row 53, Column G, then put 50 D’s in column G below that H.

And so on and so forth for the rest of that list of materials.

The number of materials on "ListofMaterials" will change each time I run the Macro.

Does that make sense?

I attached a copy of what this example would look like.

Thanks again.

Awesome. Thank you. It works perfectly.