ammarimtiaz
New Member
- Joined
- Oct 17, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi,
I have a sheet in a workbook that displays results based on a drop-down list in that sheet. For example, if you choose "Site 1" from the list it will show the data pertaining to "Site 1" in that sheet.
There are about 100 different options (100 different Sites) in the drop-down list.
I am not familiar with VBA at all, I was hoping to get a code that would select each option from the list then copy it and paste it as values and formatting to a new workbook one by one to a new sheet within that workbook.
The data to be pasted to the new workbook should be on each individual sheet. For example, 100 sheets for 100 options (Sites) for the drop-down list, and each sheet is named as its respective option from the drop-down list.
I have a sheet in a workbook that displays results based on a drop-down list in that sheet. For example, if you choose "Site 1" from the list it will show the data pertaining to "Site 1" in that sheet.
There are about 100 different options (100 different Sites) in the drop-down list.
I am not familiar with VBA at all, I was hoping to get a code that would select each option from the list then copy it and paste it as values and formatting to a new workbook one by one to a new sheet within that workbook.
The data to be pasted to the new workbook should be on each individual sheet. For example, 100 sheets for 100 options (Sites) for the drop-down list, and each sheet is named as its respective option from the drop-down list.
