Forum Discussion
Excel help
Hello
I have a badge work excel book for keeping track of badge work.
I have uploaded a example of the work boo.
The membership register tab is where I add new names and this page gets sorted by age.
The tabs camps, events, hikes, bronze, silver, gold, achievement, special interest and grey wolf all get the names from the membership register.What I want to be able to do is when I update the membership register and sort it to age all the names on the other tabs more around but the info under there name doesn't stay with the name. How do I get the info to stay under that name in the tabs camps, events, hikes etc.
1 Reply
Hey Nathan-
I hate to be the bearer of bad news, but based on the file you provided this is not possible. There is nothing linking the data in the column to the Name. When you sort the names on the membership Register (Ages) worksheet it will automatically change the name order on the dependent sheets Camps, Hikes and Events leaving your data out of order.
I would suggest trying to restructure your workbook to have one data entry tab that collects all of the pertinent information. Then you can use Pivot Tables or formulas to create "summary" worksheets for the different activities: Camps, Hikes, Events.... etc.
