I have this excel worksheet that I'm trying automate most of what I'm doing however I feel this is a little too advanced for me. I have the sheet names in cells(B2:B61). It will copy and paste data from D:I with the row that the sheet name is in and at the bottom of that sheet after the last row with data it will paste the copied data. An example is below. The main worksheet is called "Main".
On worksheet "Main" B2 is "MTP" the data is from D2:I2. Copy D2:I2 and go to worksheet("MTP") and paste underneath the previous data ("A"&lastrow). Go back to worksheet("Main"). B3 is "RENN" the data is from D3:I3. Copy D3:I3 and go to worksheet("RENN") and paste underneath the previous data ("A"&lastrow). Loop through all worksheets(B2:B61). Once complete Worksheet("Main").Select. Hopefully, this spells out what I'm looking for and any help would be greatly appreciated.
On worksheet "Main" B2 is "MTP" the data is from D2:I2. Copy D2:I2 and go to worksheet("MTP") and paste underneath the previous data ("A"&lastrow). Go back to worksheet("Main"). B3 is "RENN" the data is from D3:I3. Copy D3:I3 and go to worksheet("RENN") and paste underneath the previous data ("A"&lastrow). Loop through all worksheets(B2:B61). Once complete Worksheet("Main").Select. Hopefully, this spells out what I'm looking for and any help would be greatly appreciated.