Forum Discussion

Betsy2125's avatar
Betsy2125
Copper Contributor
Dec 03, 2018

Combine spreadsheets into one

I have this code in Google Sheets which combines several spreadsheets, in the same workbook, into one master sheet. 

=QUERY({Sheet1!A2:C;Sheet2!A2:C;Sheet3!A2:C;Sheet4!A2:C;Sheet5!A2:C;Sheet6!A2:C;Sheet7!A2:C;Sheet8!A2:C},"where Col1 is not null")

 

All spreadsheets have the same type of information, but from different sources.  We have moved to MSoffice and I can't seem to find an easy way to do this in Excel.  Please help.

Resources