How Do I Tie Worksheets to one Work book?

  • Thread starter Thread starter Bettine S Cavanaugh
  • Start date Start date
B

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?
 
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
 
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.
 

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

linking data from one worksheet to another 1
Worksheet Lists 8
Stumped - multiple lookup criteria across worksheets 3
how do I tie multiple worksheets to one sheet in Excel? 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Grabbing criteria from one sheet and inputting needed information into another 1
How do I calculate a person's age on a specific date? (huge roster 2
How do I point to another cell 5

Back
Top