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