wombatmonkey
New Member
- Joined
- Jan 8, 2022
- Messages
- 4
- Office Version
- 2013
- Platform
- Windows
Hi all
I have a drop down list in cell A1 with different values. For example, one of the values is equal to "sheet1". There are also other sheets within the workbook that equals the different values in A1 list. Ideally, I like to pick one of the values (e.g. "sheet1") in A1 and then click on a button with an assigned macro. The macro will find the sheet name equal to A1 (e.g. "sheet1"), create a copy of the sheet into a new workbook, values only/no formulas, and then attach the new workbook, values only, to an email. Thank you in advance!
I have a drop down list in cell A1 with different values. For example, one of the values is equal to "sheet1". There are also other sheets within the workbook that equals the different values in A1 list. Ideally, I like to pick one of the values (e.g. "sheet1") in A1 and then click on a button with an assigned macro. The macro will find the sheet name equal to A1 (e.g. "sheet1"), create a copy of the sheet into a new workbook, values only/no formulas, and then attach the new workbook, values only, to an email. Thank you in advance!