I am in charge of loading students data into a spreadsheet.
I need to avoid from duplicating the same students into my file.
I have set up a way to find duplicates by entering in their telephone number.
This is accurate when loading students one by one.
Here is my problem:
It would save me days of work if I were able to merge (copy/paste) one
worksheet into the other. Is there a way I could copy/paste one student
or multiple students into my database AND still having it detect duplicates?
***if it has to be one by one, it's still better than my current method.
***if i can paste in multiples it would be best.
*although I detect by phone number, here are the fields I have to type for
each student: phone 1, first name, last name, address, city, state, zip, phone 2,
phone 3, birthdate, emergency cntct, relationship, emer address, emer city, emer state,
emer zip, date entered, stud grade, notes..... etc. ***see why copy/paste is needed.