Hi,
I am trying to build a simple entry table for a non-Excel user to enter data for billing (she is my daughter's ice skating coach). For each line, the user will enter various info on type of charge, length of time on ice, etc. Then, I would like her to be able to just put X's (in the same row) under the names of the girls for which that charge applies.
At the end, I would like to have a table where I can create a pivot table (with slicers) to allow her to choose the month and the student and create the invoice. I'm ok with almost all of it...I can get the individual rows to repeat for the number of students per section (this changes with each section). I know how small works, but for the life of me, I cannot figure out how to repeat the "small" formula for the number of X's (students) indicated.
I have uploaded a file as this will be far easier to see than I can explain. The "Entry Sheet" is where the coach will enter data. The Working DB is my attempt to create the database I need for the future pivot and slicers.
I really hope this makes sense. Thanks so much in advance! *fingers crossed*
Karolyn
p.s. I could not figure out how to post anything under "Introduce Yourself".
I am trying to build a simple entry table for a non-Excel user to enter data for billing (she is my daughter's ice skating coach). For each line, the user will enter various info on type of charge, length of time on ice, etc. Then, I would like her to be able to just put X's (in the same row) under the names of the girls for which that charge applies.
At the end, I would like to have a table where I can create a pivot table (with slicers) to allow her to choose the month and the student and create the invoice. I'm ok with almost all of it...I can get the individual rows to repeat for the number of students per section (this changes with each section). I know how small works, but for the life of me, I cannot figure out how to repeat the "small" formula for the number of X's (students) indicated.
I have uploaded a file as this will be far easier to see than I can explain. The "Entry Sheet" is where the coach will enter data. The Working DB is my attempt to create the database I need for the future pivot and slicers.
I really hope this makes sense. Thanks so much in advance! *fingers crossed*
Karolyn
p.s. I could not figure out how to post anything under "Introduce Yourself".