Hello
Can anyone please provide a code snippet to get the below requirement done.
Please refer to the attached file.
Sheets("Home") : User will feed worksheet name in columnF and columnG has the range to be copied.
The requirement is to recognize the worksheet name and go to the sheet, copy range and paste into the Metrics sheet. The same flow for the next available value under home sheet columnF & G.
Please this can be done by 2 ways;
1. We can either move all those ranges one by one directly into new email
2. Or utilize the "Metrics" sheet, paste those ranges as images one by one and export into new email at once (mail range into body of the email)
Please advise. Attached sample file for your reference.
Thanks in advance
K
Can anyone please provide a code snippet to get the below requirement done.
Please refer to the attached file.
Sheets("Home") : User will feed worksheet name in columnF and columnG has the range to be copied.
The requirement is to recognize the worksheet name and go to the sheet, copy range and paste into the Metrics sheet. The same flow for the next available value under home sheet columnF & G.
Please this can be done by 2 ways;
1. We can either move all those ranges one by one directly into new email
2. Or utilize the "Metrics" sheet, paste those ranges as images one by one and export into new email at once (mail range into body of the email)
Please advise. Attached sample file for your reference.
Thanks in advance
K