I have one workbook that is a full choir roster and three separate
worksheets, one for women voices, one for men and one for children all with
addresses, etc. How can I tie them together so when I update one of them it
will update the full choir roster?

Bettine,

Don't do it that way. Use just one sheet, with an extra column that indicates which voice the singer
has: man, woman, child. Then use data filters to filter your data table based on that extra column
to look at, for example, just the men.

HTH,
Bernie
MS Excel MVP


"Bettine S Cavanaugh" <Bettine S wrote in message
...
I have one workbook that is a full choir roster and three separate
worksheets, one for women voices, one for men and one for children all with
addresses, etc. How can I tie them together so when I update one of them it
will update the full choir roster?

Thanks, I'm actually doing it for a friend, so I'll try that and see how he
likes it. Good idea and much easier to work with.


"Bernie Deitrick" wrote:

Bettine,

Don't do it that way. Use just one sheet, with an extra column that indicates which voice the singer
has: man, woman, child. Then use data filters to filter your data table based on that extra column
to look at, for example, just the men.

HTH,
Bernie
MS Excel MVP


"Bettine S Cavanaugh" <Bettine S wrote in message
...
I have one workbook that is a full choir roster and three separate
worksheets, one for women voices, one for men and one for children all with
addresses, etc. How can I tie them together so when I update one of them it
will update the full choir roster?