I have had a problem within my spread sheet where it would not allow me to retain data and overwrite it, and I was advised to implement VBA code.
Final System V3 (with data) without update.xlsm
The code that you have created works perfectly however the coding ends where the ‘KS5’ section ends , is it possible to have the same code run through the sheet so that the same effect happens? however it must be dependant on the KS4grades/Effort and KS3grades/Effort toggle options respectively.
Bookmarks