VBA to FIND, COPY, PASTE CELL

[gcr114]

Hello all! This is my first post! I have read a lot of posts on MrExcel and it's been very helpful! However, I haven't been able to find a solution to my current problem.

I have an excel file (can't share the exact file due to privacy issues) but basically its a document with several columns of information. For example:

Column A = Groups
Column B = Group Leader
Column C = 2nd Group Leader

Example:

Column A Column B Column C
A Joe Mike
B Josh Joe
C Mike Joe
D Joe Josh

I need to write a macro that will go through and on a new work sheet list each member and the groups that each member belongs to, it can be two seperate marcos, as Group Leader and Group Member needs to be seperate

Example:


Column A(Group Leader) Column B
Joe E
B

Josh B

Mike C

____________________________________

Column A(Group Member) Column B
Joe B
C

Josh D

Mike A

Then this would be repeated for group members. Sorry if it's confusing, and thanks in advance!

 

[mirabeau]

Hi,

Could you look at the FAQ for the forum to see how to post examples from a worksheet in a form where readers can see clearly which columns, which cells etc. the various items are in and where you want them to be.

The actual data you have provided, Joe etc. are fine as example. I just can't make much sense of your desired layouts.