linking multiple roles (rows) to a user (cell)

Y

Yoesrie

Hi

I am managing a conference database where some delegates have multiple
presentations and roles such as chairs, rapporteurs, etc.

I am having some difficulty designing this on Excel 2003, where I could use
the autofilter funcionality effectively, eg: if x does 1 and 2, how do I lay
it out? Do I:

1. Place 1 & 2 in the same column (roles) and 'merge and centre' 1 to cover
the two rows? The challenge with this approach is that there are many info
columns (demographics, accommodation, travel, etc.) attached to delegate x
that will also have to be merged.
2. Place 1 & 2 in adjacent columns (role1 & role2) in x's row. This makes
sense, but plays havoc with my filtering and reporting.

Can anyone help?

Yoesrie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro from columns to rows but adding every time a new line 2
linking a cell to multiple cells in another table 1
Showing data unigue to multiple columns in a pivot table 1
linking multiple sheets to a summary sheet 1
Need to split a cell into multiple rows 2
VBA Code to Use "Name" in a cell as a reference 1
Referring to multiple worksheets via a variable 2
Using Data entered in Textboxes in a User Form to filter a workshe 1

Top