palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
From the start, let me say that what I want to achieve isn't possible with Google sheets due to the number of macros and vb written into my spreadsheet.
I'd like to replicate the functionality of a spreadsheet that a former Department Head made (several years ago) that allowed multiple users to add changes to the one original spreadsheet without them all being in that one original spreadsheet at the same time which is a big issue for us ... maths teachers trying to access the same spreadsheet at the same time.
He made it so that the original 'Master' spreadsheet had several exact copies made (one for each teacher who teaches that particular subject).
Each copy was coded, so when the teacher had finished adding their changes (which would only be for the students in their particular class .. hence, no other teacher would ever be changing the same cell on their particular copy of the original as each student would have their own row) they would close the spreadsheet, and on closing, the code would do two things ....
1. save any changes (that had been made to that copy since it's previous save) over to the original.
2. save the copy as a copy of the newly updated original
The Department Head left a few years ago and never shared with us how he coded the spreadsheets.
As mentioned earlier, Google Sheets won't do this for me as my spreadsheet has far too many macros, UserForms and VB coding.
Can anyone think what the coding might have been that our former Head used ?
Any help on this would be greatly appreciated.
Very kind regards,
Chris
I'd like to replicate the functionality of a spreadsheet that a former Department Head made (several years ago) that allowed multiple users to add changes to the one original spreadsheet without them all being in that one original spreadsheet at the same time which is a big issue for us ... maths teachers trying to access the same spreadsheet at the same time.
He made it so that the original 'Master' spreadsheet had several exact copies made (one for each teacher who teaches that particular subject).
Each copy was coded, so when the teacher had finished adding their changes (which would only be for the students in their particular class .. hence, no other teacher would ever be changing the same cell on their particular copy of the original as each student would have their own row) they would close the spreadsheet, and on closing, the code would do two things ....
1. save any changes (that had been made to that copy since it's previous save) over to the original.
2. save the copy as a copy of the newly updated original
The Department Head left a few years ago and never shared with us how he coded the spreadsheets.
As mentioned earlier, Google Sheets won't do this for me as my spreadsheet has far too many macros, UserForms and VB coding.
Can anyone think what the coding might have been that our former Head used ?
Any help on this would be greatly appreciated.
Very kind regards,
Chris