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?
Highlighted

@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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies