Refrence cells in one table multiple times in another table

[jthoni]

I am using Excel to track participation in a fund raising event. In one sheet, I have a table that lists all of the people, and whether or not they participated. I want there to be just one record for each person as I use this for other purposes as well (such as mail merge). As funds come in, I want to track that in another table. I want to have a separate record for each contribution they bring in. I want to use a reference to the first table, but I can't find an easy way to get all the data I want without having to build each row. If I have A1, A2 and A4 reference C5, C6 and C9 on another sheet, if I copy and paste to the next row, I get D5, D6 and D9. This is great for the next person, butI want another record for the same person.

I guess this would be like a situation where you have a customers table and an orders table. Multiple orders linking to one customer.

Any tips?

Thanks,
~john

[DonkeyOte]

Welcome to the Board.

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.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.