Stuck on creating VBA script if and else?????

[exceljen86]

Hi all,

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?

 

[Comfy]

Like I said, quite a lazy post. I was a bit tired last night.

The table that contains the "Y's" is this an Excel table? (ListObject) like my use of a table for the sheet names.

 

[exceljen86]

I've done it now, I'd just typed the cell references in wrong (Put =C3 instead of just C3). It works perfectly now!!!!!

Thanks!!!