I'm building a spreadsheet of infomation for some regional branches of a club
I'm involved with, to summarise their activities. The problem is that the
number of items of information varies from branch to branch and I don't want
to have a mile-wide spreadsheet putting all the data in consecutive columns.
For example, most branches have one secretary, but others share out this
role. I'd like to put the second secretary's details in the row below and
then 'collapse' the data so that it's accessible but not always visible.
Another branch runs two sets of meetings for different interest groups, with
different dates and topics, so I'd like to put info for the second group in a
second row (but still using the same columns for dates and topics). If I
were doing this in Access, I'd be able to do it with a one-to-many
relationship between the relevant tables, but my colleagues aren't so
familiar with Access, so I've been asked to use Excel. I've thought about
using Group and Outline but will that enable me to have a number of different
outlines, or do the levels of detail have to be 'nested'. Any suggestions
would be very welcome, thanks in advance.