I want to create a macro that loops through a data validation list I have located in cell C8on the sheet named Gym Weekly Template. For each value in the data validation list, I have a vlookup value that generates in cell W73 of the same sheet.
I want to paste each value from cell W73 to a new worksheet named Gym Load Monitoring starting at cell B2 and down the B column, ending the macro once the data validation list has been looped through.
If possible, if I was to run the macro again I want it to recognize there is data in column Bin worksheet Gym Load Monitoring and paste the values in the next blank column, and so on for each time, the macro is run.
Any help would be greatly appreciated. Let me know if I need to add more information