MACRO copy/paste different criteria to separate worksheets?

Hello all,

I am very new to VBA and have just started using Macros recently.

I have a workbook that contains 6 columns of data. The last column of data contains names of devices pertaining to 2 specific groups, and I need to filter each of these device names to their corresponding groups and separate them. Each group has a different worksheet within the book.


The basics are:

- I need two destination worksheets (VPN/MSI)
- The VPN sheet has to contain all devices ending in -me2 & -me4.
- The MSI sheet has to contain all devices ending in -th8.
- All devices are in Column F
- There will only be devices ending with these characters; no other endings. However, the first 8 letters will all be different. (ex: *th8)
- The source is Sheet1 and the size will vary depending on the device, so I think I'd need a loop on this?

Eventually I'll be playing around with the VBA to meet more specific needs, however I'd like to play around and figure that out on my own. Starting from scratch on this "base" macro has been too difficult for me! Any help would be greatly appreciated and will give me a good starting point for learning how to do this on my own.

I've tried following http://www.rondebruin.nl/copy5_2.htm but I don't know how to add another destination sheet that meets my criteria.

Thanks everybody!

edit: I've attached a copy of my sheet

Notification.xlsm