How To Update a Master Spreadsheet from Spreadsheets within the same workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2593014%22%20slang%3D%22en-US%22%3EHow%20To%20Update%20a%20Master%20Spreadsheet%20from%20Spreadsheets%20within%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2593014%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20have%20the%20data%20presented%20on%20individual%20spreadsheets%20within%20a%20workbook%20automatically%20update%20a%20master%20spreadsheet%20in%20the%20workbook%20with%20the%20same%20information%20for%20report%20presentation%20purposes.%20The%20data%20is%20being%20copied%20from%20OneNote%20into%20the%20individual%20spreadsheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20automatically%20update%20the%20master%20spreadsheet%20with%20the%20data%20from%20the%20individual%20spreadsheets.%20This%20is%20not%20duplication%20of%20data%20entry%20but%20a%20matter%20of%20presentation%20in%20two%20different%20ways.%20I%20have%20a%20basic%20understanding%20of%20Excel%20formulas%3B%20however%2C%20accomplishing%20this%20task%20has%20so%20far%20eluded%20me.%20How%20can%20I%20get%20this%20done%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2593014%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2593541%22%20slang%3D%22en-US%22%3ERe%3A%20How%20To%20Update%20a%20Master%20Spreadsheet%20from%20Spreadsheets%20within%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2593541%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1114020%22%20target%3D%22_blank%22%3E%40CarlaKdmps%3C%2FA%3E%26nbsp%3BHave%20you%20used%20PowerQuery%20before%3F%20You%20can%20fairly%20easily%20combine%2Fappend%20individual%20sheets%20into%20a%20single%20one%2C%20provided%20that%20all%20sheets%20are%20structured%20in%20the%20same%20manner.%20Please%20upload%20an%20example%20of%20your%20file%20with%20some%20fake%20data%2C%20but%20realistically%20representing%20what%20you%20are%20dealing%20with.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20then%20I%20take%20your%20word%20for%20it%20that%20you%20really%20must%20copy%20the%20OneNote%20data%20into%20individual%20sheets.%20But%20it%20would%20make%20it%20a%20lot%20easier%20if%20you%20could%20copy%20all%20into%20the%20master%20sheet%20to%20begin%20with%2C%20and%20extract%20whatever%20sub-sets%20of%20data%20you%20need%20from%20there.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need to have the data presented on individual spreadsheets within a workbook automatically update a master spreadsheet in the workbook with the same information for report presentation purposes. The data is being copied from OneNote into the individual spreadsheets.

 

How do I automatically update the master spreadsheet with the data from the individual spreadsheets. This is not duplication of data entry but a matter of presentation in two different ways. I have a basic understanding of Excel formulas; however, accomplishing this task has so far eluded me. How can I get this done?

1 Reply

@CarlaKdmps Have you used PowerQuery before? You can fairly easily combine/append individual sheets into a single one, provided that all sheets are structured in the same manner. Please upload an example of your file with some fake data, but realistically representing what you are dealing with.

 

And then I take your word for it that you really must copy the OneNote data into individual sheets. But it would make it a lot easier if you could copy all into the master sheet to begin with, and extract whatever sub-sets of data you need from there.