Excel Contact List help

**dlawny** · 06-03-2012, 04:46 PM

Hello,
I am hoping someone can help me. I am using Excel 2007 and I have been give a contact list. The list contains a person's name, email, phone, address. The last piece that has to be added to this spreadsheet is the ability to add against any person's name the event (conference, visitor, etc) that the person attended. This is for my church; so some people have filled out for different events. We need to be able to sort out the contacts by the different events or conferences or ministry's that is applicable to them in order contact them for future events.

Please help!

**Spencer101** · 06-03-2012, 04:51 PM

Hi,

I think an example workbook is needed here. You'll want to use dummy information where possible as it concerns personal information.

If you could provide a small dummy sample and an idea of what it needs to look like 'after' that would make it easier to help.

S.

**FDibbins** · 06-03-2012, 10:54 PM

it almost sounds like you need to use a sheet as a data base for this, because im thinking that some people would attend multiple events?

then you could maybe construct a simple pivot table or something similar that would give you what you need.

however, as suggested, without a sample to work with, its a little difficult to offer suggestions without seeing something?