hiding whole cells, not just the information....

[gioshm]

hi, i really don't know which forum this would go under, maybe you could direct me where to put it.

I have an address book in excel with some extra information that lists clubs that my entries are in and meeting dates for specific members. when a specific date approaches, I have a word document that has blank fields that auto populate from the information in excel (address field, name field, meeting date field, club name field, etc...)

what currently happens now is that if someone is in multiple clubs, they receive 1 letter for each club. in the excel sheet, is there a way to list multiple club names on one row but using only one cell (or is as easily remedied as listing multiple clubs in once cell separated by a comma or semicolon)? kind of like a drop down menu when you hover your mouse over the cell or click on the cell? so that on the word document, instead of getting 5 newsletters for 5 clubs, I can have one newsletter go to one member with another empty field that populates if they belong to multiple clubs?

does this make any sense?

[FDibbins]

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[gioshm]

wow Ford, you fast, boss! ok i'll attach a dummy sheet. as an extra, is this the correct forum for that question or does it go somewhere else?

[FDibbins]

This forum will do for now. If we need to move it, I can do that for you

[gioshm]

You rock Ford.

Ok in the attached file (address dummy list), there would be a total of 7 newsletters mailed out. is there a way to consolidate bob into once line and josh into one line and somehow hide the multiple clubs, floor, room, leader, meet time (and just have one option show as their main club, room, leader, meet time so that bobs info shows all in just one row but still have each of those clubs, floors, rooms, leaders, meet time be reported in their own cells so i can reference them in other excel sheets and what not?

[FDibbins]

I am out of time right nem will take a look again soon

[FDibbins]

hmm Im wondering if a Pivot Table will help here.

Play around a bit and see what you come up with?
(Im back for a while, so let me know how you make out)

[gioshm]

sorry. i only know the basic definition of what a pivot table is. i don't even know how to make one but I don't know if that would help. maybe i'm making it more complicated that I should. maybe i should just change the size of the extra rows to just 1.....