VBA to import data from one category into another

[PipBoy808]

Hold the phone, I got it working! YES! Now, the next step is to arrange the output data. Thanks so much to all of those who contributed

 

[Luke M]

Hmm. Several q's to check things.

1. Is the code currently in the same workbook as data, or in another workbook? If the latter, there were a couple lines in the code that you'll need to uncomment/change to make things work
2. As you step through the code, can you see what sheet is active when the Filter tries to activate?
3. Does the Filter fail on first loop, or one of the later ones? (aka, what value is i at?)

EDIT. Ah, I see that you got it figured out. Woohoo!

 

[SirJB7]

Hi, PipBoy808!
Consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you. Thank you.
Regards!

EDITED

PS: Omit this post, I didn't see you solved it yet. Glad you did it!

 

[Luke M]

@SirJB7
Glad to see I'm not the only one who got tricked by the "follow-up post on 2nd page of thread" phenomenon.