exceljen86
New Member
- Joined
- Nov 26, 2015
- Messages
- 15
Hi all,
I have and "input" sheet in my workbook with a table like this
<tbody>
</tbody>
I want to use it so that every "Y" put in the right column would select certain sheets and then at the end it would copy all of the sheets into a new workbook.
but every way I try I come up blank. I thought of just using if and else and putting every scenario in, but that would take forever. Anyone have any ideas please?
I have and "input" sheet in my workbook with a table like this
Type 1 | Y |
Type 2 | |
Type 3 |
<tbody>
</tbody>
I want to use it so that every "Y" put in the right column would select certain sheets and then at the end it would copy all of the sheets into a new workbook.
but every way I try I come up blank. I thought of just using if and else and putting every scenario in, but that would take forever. Anyone have any ideas please?
Last edited: