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.
By: Dave H