fantabulator
Member
Hello all,
Must say this site is awesome!!!Haven't had a problem yet that there was not someone with a solution. Was even just able to use some of what I learned to help someone else.
Here is another problem that is bending my mind. I am using excel to track student assignments - missing, late and on time, using a time stamp formula.
I have also recently synced the spreadsheets to a CSV file created by the mark grading program we use, so I can import student mark, absences, and last and first name. I use this information, particularly the student names to populate all areas of my worksheets that require names.
So now the problem....as the semester starts, there is a bit of variability in the first few months with students coming and going from the class.
If I allow the names to be dynamically updated and overwrite the positions of the current names, all of the data would be skewed to the wrong person.
If someone could even point me in the right direction in terms of logic and formulas, I would try to work out how it fits my situation.
Thanks for any help,
Must say this site is awesome!!!Haven't had a problem yet that there was not someone with a solution. Was even just able to use some of what I learned to help someone else.
Here is another problem that is bending my mind. I am using excel to track student assignments - missing, late and on time, using a time stamp formula.
I have also recently synced the spreadsheets to a CSV file created by the mark grading program we use, so I can import student mark, absences, and last and first name. I use this information, particularly the student names to populate all areas of my worksheets that require names.
So now the problem....as the semester starts, there is a bit of variability in the first few months with students coming and going from the class.
If I allow the names to be dynamically updated and overwrite the positions of the current names, all of the data would be skewed to the wrong person.
If someone could even point me in the right direction in terms of logic and formulas, I would try to work out how it fits my situation.
Thanks for any help,