Transfer Data from one workbook to another

Question

Hi everyone,&nbsp;&nbsp;I am trying to figure out the best way to use a master excel sheet to an overview for each individual.&nbsp; The data is the same on the individual sheet but needs to use the data from each row.&nbsp; What is the best way to do this without going through each individual sheet and linking each row for each student? I have been doing it yearly by linking each row from the master sheet to the individual sheets.&nbsp; I know there must be an easier way.&nbsp;&nbsp;Thank you in advance

twifoo · Answer

I see only one sheet in your attached file. Where are the individual sheets you are referring to?

jmitchell · Answer

Twifoo&nbsp;I apologize.&nbsp; I have attached the individual payment sheets that I want the information transferred into.&nbsp; In the past, I have linked each cell to the master sheet, but I know there has to be an easier way.&nbsp; I want to put the data in the master sheet and have it automatically transfer to the individual sheets.&nbsp; I may need to rework the entire master sheet or individual sheets.&nbsp; Any guidance would be greatly appreciated!!!&nbsp; :)&nbsp;

twifoo · Answer

Please also attach the master sheet in your attached file. Remember to manually enter your desired results in the master sheet. Thereby, I can decipher the formulas you need.

jmitchell · Answer

Twifoo&nbsp;I have attached the master sheet and the "practice individual sheets" that I am using.&nbsp; I need the data from the master sheet to be placed into the individual sheets.&nbsp; I want to be sure that if I change information on the master sheet that it will be updated to the individual sheets.&nbsp; I want the master sheet to be my working document and be able to print the individual sheets for the students.&nbsp;&nbsp;&nbsp;I have indicated where I want the data to come from off the master sheet onto student 1 individual sheet.&nbsp; I only did the first two payments, but it would continue in the same manner for the remainder of the payments.&nbsp;&nbsp;&nbsp;Thank you&nbsp;&nbsp;

jmitchell · Answer

Twifoo&nbsp;&nbsp;Not sure if both files are attaching.&nbsp; Here is the master sheet as well.&nbsp;&nbsp;

Forum Discussion

Transfer Data from one workbook to another

7 Replies