Auto-Populate a sheet from source sheet based on source sheet cell data in column

[Cbutts]

Hello smart people!
I've been trying to figure this out and I've searched around the forum for something that could suit my needs. All I managed to do was confuse myself further.


I have a master die list 12 data columns wide....722 Rows (so far, it will grow) SAMPLE ATTACHED
What I want to do is create more sheets named appropriately, and auto populate those sheets with the same 12 columns, pulling only the rows that match the data located in Column K (CUT) of my master sheet.
Column K contains data such as "DC" (die cut), "PF" (perforation), "BC" (butt cut), "CR" (circle), etc.

Example:
I want to auto populate a new sheet named "Die Cut" with all of the rows containing "DC" in Column K of my master sheet and then auto-sort those rows "ascending" based on the data in column D (WIDTH)

It seems easy enough, but I haven't been able to make anything work. Any help is greatly appreciated.

[torachan]

give the attached a trial - there is a macro on the combobox on the 'Master Sheet' - if you copy your data into the table on the 'Master Sheet' the table should expand dynamically to accommodate.

[Cbutts]

Hi torachan,
I tried opening the document, but it tells me it uses active x and that isn't supported in Excel 2011 Mac. It only allows me to open in Read Only mode.

[torachan]

Sorry, did not see in your profile you are using a Mac, the attached file hopefully will work, I have used the Forms ComboBox rather than the ActiveX ComboBox - same principle just needed some code tweaking.

[Cbutts]

I got an error on this one as well. [screenshots] It certainly tried to work. When I exited debugger Sheet "PF" had some data on it.
Screen Shot 2022-10-21 at 8.16.29 AM.jpg


Now that I see what you're doing I should also add that there are 3 items not represented in the K column of the test file. Those being "BC", "LNR" and "LSR SHEET". I'm not sure if you need to know that on the front end or if the code will just add a sheet for whatever it finds in that column.

[torachan]

Hi. the attachments are invalid, I do not think the paperclip work, use 'insert image' in the menu bar of the 'quick reply' box.
hopefully someone with a 'Mac' will see this and look through the code (it works OK with Windows 11 - Excel 2010) most likely some reference that 'Mac' does not recognise.
The 3 other item would have to be added to the array in the code and corresponding code inserted (it is fairly obvious what and where to someone with VB knowledge)

[Cbutts]

Thanks torachan,
I updated the photos.
I've got very limited VB knowledge but I do see where the items should be added to the array.
Maybe someone will offer a fix for the Mac thing.
Thanks for your time!