View Single Post
 
Old 02-14-2019, 08:51 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Open a blank sheet, go to data tab, select consolidate. A dialogue box will pop out, click the browse button, select your January file. I presume that you have headers in your files so check the "row headers", click "add". Repeat the same process until the last sheet that you want to add in the consolidated data. To make the consolidation process easier, remove all merged cells.
Reply With Quote