I run a report every month for dozens of products
the number of products differ each month (we add and remove products on a monthly basis)
the product names are in a worksheet called "cross reference" they start in cell GZ18 and go down to any line
I need to place the product name in cell EX20 in the worksheet "attribution report"
once the name is in cell EX20 a report is automatically run and stored in the separate worksheet.
right now I have the produce names hardcoded in a macro that repeats the same 10ish lines of code dozens of times (once for each product). I currently have to edit the code to remove the code for the deleted products and add code for the new products
I repeat the same code each time
what I want to do is is run a macro that places the first product name from starting from cell "cross reference" GZ18 into "attribution report" cell EX20
once there the report will run and be stored
I then want to go back to the list and put the next name until I reach the end of the list
the number of products differ each month (we add and remove products on a monthly basis)
the product names are in a worksheet called "cross reference" they start in cell GZ18 and go down to any line
I need to place the product name in cell EX20 in the worksheet "attribution report"
once the name is in cell EX20 a report is automatically run and stored in the separate worksheet.
right now I have the produce names hardcoded in a macro that repeats the same 10ish lines of code dozens of times (once for each product). I currently have to edit the code to remove the code for the deleted products and add code for the new products
I repeat the same code each time
what I want to do is is run a macro that places the first product name from starting from cell "cross reference" GZ18 into "attribution report" cell EX20
once there the report will run and be stored
I then want to go back to the list and put the next name until I reach the end of the list