Searching for specific words in sheet for attendance list

Hi everyone,

I'm new to this forum and VBA programming, so I have no idea what to expect and what is too much to ask for, but here it goes.

I want to make a VBA macro that makes attendance list.
The data in the main sheet consists all the names and contact details of my scouting group.
In one column (column AC) is specified wich group the kids are in (like cubs, scouts etc.)

The goal of the VBA code is to look for the name of a group (cubs or scouts etc.) in column AC and then copy certain cells from the row in wich the group name is found. Then, it has to paste these cells into another sheet, wich has the name of the group.
This way I want to make attendance lists that only have the membership number, full name and phone number of the kids. Every group will get their own sheet, so that whenever we have new members, the only thing that is needed is update the main sheet (wich is an .xml file I download from our online system).

Is this in any way possible?

The details are:
Item----------Collumn in main sheet--Column in group sheet
Group name------------AC-------------------not needed
Membership number---A-------------------------A
Full name---------------F-------------------------B
Phone number----------O------------------------C

Please let me know if this is in any way possible and if more info is needed.

I'd rather not post the original file, because it contains all the personal info of our members. I added a small example, in English. Hope it helps

I'm looking forward to your input!
Best regards from Holland,

- Daan

Thank you for posting an example file. It is appreciated, and the best way to get a quick and accurate response. Let me know if you don't know to insert this code, or if you want help with a trigger (the code runs on a button press, or everytime the worksheet changes, or etc.).

Please Login or Register  to view this content.

Heres another way

Please Login or Register  to view this content.