Home

Transfer Data from one workbook to another

%3CLINGO-SUB%20id%3D%22lingo-sub-583698%22%20slang%3D%22en-US%22%3ETransfer%20Data%20from%20one%20workbook%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583698%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20figure%20out%20the%20best%20way%20to%20use%20a%20master%20excel%20sheet%20to%20an%20overview%20for%20each%20individual.%26nbsp%3B%20The%20data%20is%20the%20same%20on%20the%20individual%20sheet%20but%20needs%20to%20use%20the%20data%20from%20each%20row.%26nbsp%3B%20What%20is%20the%20best%20way%20to%20do%20this%20without%20going%20through%20each%20individual%20sheet%20and%20linking%20each%20row%20for%20each%20student%3F%20I%20have%20been%20doing%20it%20yearly%20by%20linking%20each%20row%20from%20the%20master%20sheet%20to%20the%20individual%20sheets.%26nbsp%3B%20I%20know%20there%20must%20be%20an%20easier%20way.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-583698%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-584353%22%20slang%3D%22en-US%22%3ERe%3A%20Transfer%20Data%20from%20one%20workbook%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-584353%22%20slang%3D%22en-US%22%3EI%20see%20only%20one%20sheet%20in%20your%20attached%20file.%20Where%20are%20the%20individual%20sheets%20you%20are%20referring%20to%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-623455%22%20slang%3D%22en-US%22%3ERe%3A%20Transfer%20Data%20from%20one%20workbook%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-623455%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20apologize.%26nbsp%3B%20I%20have%20attached%20the%20individual%20payment%20sheets%20that%20I%20want%20the%20information%20transferred%20into.%26nbsp%3B%20In%20the%20past%2C%20I%20have%20linked%20each%20cell%20to%20the%20master%20sheet%2C%20but%20I%20know%20there%20has%20to%20be%20an%20easier%20way.%26nbsp%3B%20I%20want%20to%20put%20the%20data%20in%20the%20master%20sheet%20and%20have%20it%20automatically%20transfer%20to%20the%20individual%20sheets.%26nbsp%3B%20I%20may%20need%20to%20rework%20the%20entire%20master%20sheet%20or%20individual%20sheets.%26nbsp%3B%20Any%20guidance%20would%20be%20greatly%20appreciated!!!%26nbsp%3B%20%3A)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-623502%22%20slang%3D%22en-US%22%3ERe%3A%20Transfer%20Data%20from%20one%20workbook%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-623502%22%20slang%3D%22en-US%22%3EPlease%20also%20attach%20the%20master%20sheet%20in%20your%20attached%20file.%20Remember%20to%20manually%20enter%20your%20desired%20results%20in%20the%20master%20sheet.%20Thereby%2C%20I%20can%20decipher%20the%20formulas%20you%20need.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-623608%22%20slang%3D%22en-US%22%3ERe%3A%20Transfer%20Data%20from%20one%20workbook%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-623608%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20the%20master%20sheet%20and%20the%20%22practice%20individual%20sheets%22%20that%20I%20am%20using.%26nbsp%3B%20I%20need%20the%20data%20from%20the%20master%20sheet%20to%20be%20placed%20into%20the%20individual%20sheets.%26nbsp%3B%20I%20want%20to%20be%20sure%20that%20if%20I%20change%20information%20on%20the%20master%20sheet%20that%20it%20will%20be%20updated%20to%20the%20individual%20sheets.%26nbsp%3B%20I%20want%20the%20master%20sheet%20to%20be%20my%20working%20document%20and%20be%20able%20to%20print%20the%20individual%20sheets%20for%20the%20students.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20indicated%20where%20I%20want%20the%20data%20to%20come%20from%20off%20the%20master%20sheet%20onto%20student%201%20individual%20sheet.%26nbsp%3B%20I%20only%20did%20the%20first%20two%20payments%2C%20but%20it%20would%20continue%20in%20the%20same%20manner%20for%20the%20remainder%20of%20the%20payments.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-623618%22%20slang%3D%22en-US%22%3ERe%3A%20Transfer%20Data%20from%20one%20workbook%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-623618%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20if%20both%20files%20are%20attaching.%26nbsp%3B%20Here%20is%20the%20master%20sheet%20as%20well.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-632303%22%20slang%3D%22en-US%22%3ERe%3A%20Transfer%20Data%20from%20one%20workbook%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-632303%22%20slang%3D%22en-US%22%3EPerhaps%2C%20you%20misunderstood%20my%20earlier%20request.%20I%20will%20make%20it%20clearer%20this%20time.%20I%20request%20you%20to%20attach%20your%20sample%20file%20with%3A%3CBR%20%2F%3E1.%20The%20master%20sheet%3B%20and%3CBR%20%2F%3E2.%20The%20individual%20sheets.%3CBR%20%2F%3ENote%20that%20all%20of%20the%20foregoing%20sheets%20must%20be%20contained%20in%20ONLY%20ONE%20sample%20file.%20Enter%20your%20formulas%20in%20the%20master%20sheet%20so%20I%20will%20know%20how%20the%20results%20therein%20were%20determined.%20Hopefully%2C%20we%20could%20arrive%20at%20formulas%20that%20return%20your%20desired%20results.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-656615%22%20slang%3D%22en-US%22%3ERe%3A%20Transfer%20Data%20from%20one%20workbook%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-656615%22%20slang%3D%22en-US%22%3E%3CP%3EI%20will%20put%20the%20data%20in%20the%20master%20sheet%20since%20it%20is%20payments%20received%20from%20each%20individual%20student.%26nbsp%3B%20I%20just%20need%20the%20information%20to%20be%20transferred%20into%20the%20individual%20sheets%20as%20soon%20as%20I%20update%20the%20master%20sheet.%26nbsp%3B%20I%20really%20hope%20that%20you%20will%20be%20able%20to%20assist%20me%20with%20this!!!!%26nbsp%3B%20Thank%20you%20in%20advance%20for%20your%20time.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
jmitchell
Occasional Contributor

Hi everyone, 

 

I am trying to figure out the best way to use a master excel sheet to an overview for each individual.  The data is the same on the individual sheet but needs to use the data from each row.  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.  I know there must be an easier way.  

Thank you in advance

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

@Twifoo 

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

 

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.

@Twifoo 

I have attached the master sheet and the "practice individual sheets" that I am using.  I need the data from the master sheet to be placed into the individual sheets.  I want to be sure that if I change information on the master sheet that it will be updated to the individual sheets.  I want the master sheet to be my working document and be able to print the individual sheets for the students.  

 

I have indicated where I want the data to come from off the master sheet onto student 1 individual sheet.  I only did the first two payments, but it would continue in the same manner for the remainder of the payments.  

 

Thank you 

 

@Twifoo 

 

Not sure if both files are attaching.  Here is the master sheet as well.  

Perhaps, you misunderstood my earlier request. I will make it clearer this time. I request you to attach your sample file with:
1. The master sheet; and
2. The individual sheets.
Note that all of the foregoing sheets must be contained in ONLY ONE sample file. Enter your formulas in the master sheet so I will know how the results therein were determined. Hopefully, we could arrive at formulas that return your desired results.

I will put the data in the master sheet since it is payments received from each individual student.  I just need the information to be transferred into the individual sheets as soon as I update the master sheet.  I really hope that you will be able to assist me with this!!!!  Thank you in advance for your time.  

 @Twifoo 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies