Home

Consolidating data from multiple worksheets

%3CLINGO-SUB%20id%3D%22lingo-sub-712595%22%20slang%3D%22en-US%22%3EConsolidating%20data%20from%20multiple%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712595%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20trouble%20consolidating%202%20spreadsheets%20that%20when%20the%20new%20%22Master%22%20is%20created%2C%20it%20only%20contains%20the%20header%20row%2C%20the%20first%20column%20and%20the%204th%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20the%20dialog%20box%20to%20create%20the%20references%20but%20it%20doesn't%20seem%20to%20pick%20up%20all%20the%20data%20despite%20the%20range%20appearing%20correct%20in%20the%20dialog%20box.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-712595%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-713343%22%20slang%3D%22en-US%22%3ERe%3A%20Consolidating%20data%20from%20multiple%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-713343%22%20slang%3D%22en-US%22%3ECould%20you%20please%20explain%20a%20bit%20more%3F%20perhaps%20provide%20a%20sample%20workbook%20with%20anonymized%20data%20and%20an%20explanation%20of%20what%20steps%20you%20are%20taking%20precisely%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-713613%22%20slang%3D%22en-US%22%3ERe%3A%20Consolidating%20data%20from%20multiple%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-713613%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F364273%22%20target%3D%22_blank%22%3E%40Mark_McGrath%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Mark%2C%3C%2FP%3E%3CP%3ETry%20this%20to%20see%20if%20you%20get%20in%20the%20right%20direction.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOpen%20your%20spreadsheet%20with%20your%20information%20and%20also%20a%20new%20spreadsheet%20(Book%201).%3C%2FP%3E%3CP%3EOn%20your%20original%20spreadsheet%2C%20select%20a%20tab%2C%20right-click%2C%20select%20move%20or%20copy.%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20Move%20or%20Copy%20box%2C%20make%20sure%20Book%201%20is%20selected%20and%20choose%20before%20sheet%201.%3C%2FP%3E%3CP%3ESelect%20the%20box%20for%20make%20copy.%3C%2FP%3E%3CP%3ESelect%20Ok.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20more%20than%20one%20tab%20to%20move%2C%20select%20all%20of%20the%20tabs%20before%20you%20move%20them.%26nbsp%3B%20Once%20the%20tabs%20are%20in%20the%20new%20spreadsheet%2C%20you%20can%20manipulate%20the%20data%20to%20combine%20the%20information%20-%20copy%20paste%2C%20create%20pivot%20tables%2C%20naming%20data%20and%20VLOOK%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20can%20get%20you%20in%20the%20right%20direction.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Mark_McGrath
Occasional Visitor

I'm having trouble consolidating 2 spreadsheets that when the new "Master" is created, it only contains the header row, the first column and the 4th column.

 

I'm using the dialog box to create the references but it doesn't seem to pick up all the data despite the range appearing correct in the dialog box.

 

Help?

2 Replies
Could you please explain a bit more? perhaps provide a sample workbook with anonymized data and an explanation of what steps you are taking precisely?

@Mark_McGrath 

 

Hi Mark,

Try this to see if you get in the right direction.

 

Open your spreadsheet with your information and also a new spreadsheet (Book 1).

On your original spreadsheet, select a tab, right-click, select move or copy. 

In the Move or Copy box, make sure Book 1 is selected and choose before sheet 1.

Select the box for make copy.

Select Ok.

 

If you have more than one tab to move, select all of the tabs before you move them.  Once the tabs are in the new spreadsheet, you can manipulate the data to combine the information - copy paste, create pivot tables, naming data and VLOOK up.

 

I hope this can get you in the right direction.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies