I have a list on a sheet, (Client Number, Surname), as well as check-boxes for gym sessions (AM1, AM2, AM3, AM4, PM1, PM2, PM3, PM4) in rows.
If checkboxes for AM1 and PM3 (for example) are checked, I want the client number and surname to appear on the sheets named AM1 and PM3 respectively.
I'm working on a list of about 300 people, and want to be able to simply check the sessions next to their names and have the respective session sheets seeded live as it were.
I would be grateful of any assistance as I'm a touch clueless.
Thanks in advance.
If checkboxes for AM1 and PM3 (for example) are checked, I want the client number and surname to appear on the sheets named AM1 and PM3 respectively.
I'm working on a list of about 300 people, and want to be able to simply check the sessions next to their names and have the respective session sheets seeded live as it were.
I would be grateful of any assistance as I'm a touch clueless.
Thanks in advance.