How Do I Tie Worksheets to one Work book?

[Bettine S Cavanaugh]

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?

 

[Bernie Deitrick]

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]

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.