Hey all,
I am currently in the process of voluntarily making a spreadsheet for an education centre. I have produced most of it, but I want to also make a system where I don't need to administer it. In other words, be able to be used by someone with limited Excel skills.
The spreadsheet tracks both student numbers (1st sheet) and how many students each teacher teaches (2nd sheet). Week-to-week data can easily be inputted, but I'm struggling to find a way how to solve less often events. For example, a teacher leaves or a new one arrives.
I'm sure Macros can help with this, but I'm not quite sure what to do from here. I'd like to press a button and then a new column arrives and formulas from the left of it are duplicated. From here, the 'user' only needs to input a name and some data.
Happy to answer any questions if I haven't explained the situation very well.
Thanks,
Ryan
Attached below is the spreadsheet.
Real English Student:Teacher Tracker (Gaoming Branch).xlsx
Bookmarks