Copy/Paste 30 Times or Loop?

Hi guys, I've attached below a small part of my code. I am wondering if there is a way to do this, without copying and pasting something 30 times, but using a loop instead.

As you can see there are a series of productsNumbers (30 in total, but this example is for 3). Each productNumber is a string that is actually a 5 digit number, so it can be an integer as well, if it has to.

I would like to code below to loop for as many products as there may be. The way that I have it right now does not work - I feel that I am missing something small or that there is no way to do this. Suggestions are apperciated. Thanks!

Please Login or Register  to view this content.

Hi,

It seems you've already got the guts of your loop. If I've understood correctly, delete the productnumber1, productnumber2 etc. variables.

Make the loop counter(assuming the product numbers are in a contiguous range),

Please Login or Register  to view this content.

Then in the For Each Cell..Next cell loop

Please Login or Register  to view this content.

What's the object of the code? There may be a simpler way of solving your requirement, perhaps a pivot table???

HTH