We keep master list of everyone who calls our hotline and all of our outgoing calls. Oftentime, other staff import a sheet of calls to be made, for whatever reason, there is overlap in the information but every one uses their own system.
I would love to save time by copying a row from one sheet to another and have the information fit into the master sheets categories (and the other way around). Is there a way to to this.
Master sheet colums: date, staff, name of caller, phone number, notes, student name, application ID number
Special issue sheet columns: application ID number, student name, parent name, phone number
So when copying a row it inserts the information after the regular columns of the master sheet, and I am not sure that cutting and pasting saves us any time.
Thanks in advance for any suggestions.