VBA: Loop to copy and paste data from another spreadsheet

[TaskMaster]

Hi Everyone hoping that you can help me with the following query.

I have managed to use the following code to open another spreadsheet, that pulls data in from our database based on the parameters in cells C2:C5, and then copy the results into my current spreadsheet and then save the file as the product code, (for now just my desktop). Our product code is in cell C2, C3:C5 will remain fixed. What I am hoping for is to use a loop to, repeat this process for a list of product codes in column P and save the file as the name of the product code. Is this possible and if so could anyone point me in the right direction?

Please Login or Register  to view this content.

Test.xlsm