similar data in multiple lists

Ok newbie here,very little excel knowlegde so be gentle!

I have 5 lists (say A1, B2, C3, D4, E5)- names,address etc. They are members of a club who will be posted a membership card. However, the members may belong to some or all of the lists. So potentially they could receive anything from 1 to 5 membership cards. BUT, I only want to post the one letter, to include all their cards. So I need a way of creating new list which details the clubs they belong to. Is that possible? I realise it may create a few lists but I can’t see another way round.

Hope that makes some sort of sense.

 

Thanks – I’m on a mac an have excel 2011.

 

Dave

 

By: Dave H

Leave a Reply

Your email address will not be published. Required fields are marked *