Im making a model of visitors to an attraction and trying to allow users to play with the model by altering the number or percentage of people attending (classified by their age group eg, 200 people attending in total, 50 of whom are under 10, 70 who are over 10 and under 18 and 80 who are over 18 which would give percentages of 25%, 35% and 40%). The intention is to allow the user to play with either the numbers of each group - which would alter the total number of visitors and percentage of each group OR the percentage of a Group which would retain the total number of visitors but alter the percentage of each of the other groups proportionally to their current size so the proportions between the unchanged groups remains the same. I can see that I will need more than one set of data entry places and macros to copy the data between the tables but cant seem to visualise how the process would work in use. Has anybody done something similar or able to offer advice on the principles involved?