Dynamic table based off master sheet

[cuellar]

Hello,

Attached is a spreadsheet that contains a part directory in the master sheet and then has subsheets (defined as a subassemblies) that represent groups that a part can inhabit. The subsheets can currently read single IDs in the subassembly column in the master list and appropriately place the part in the correct subassembly.

However, many parts exist in multiple subassemblies. I would like to change the code to be able to read (01,02) in the subassembly column as two entries and place the part in subsheet for 01 and subsheet 02.

Can somebody please help?

I tried this the code from mytraininghub (attached) but I couldn't get it to work.

Thanks for reading my post!

[dflak]

Before I move further on this. Do you just want to look at 01 and 02 or do you also want to look a Series1, Series2, etc.? If so, what sheets to they get sent to?

If it's just 01 and 02, I can code specifically for these parts. If it is more than that, we'll need to construct a table that matches subassembly to sheet.

[JeteMc]

Is this basically the same question as you are asking in the following thread? https://www.excelforum.com/excel-gen...ml#post4905785