asked on
Excel Question: how to count multiple external files
I would like to count a value from external Excel files
I have three files, File1.xlsx, File2.xlsx, File3.xlsx
I would like to count on a certain colum on each files and output on Count.xlsx
Please advise.
file1.xlsx
file2.xlsx
file3.xlsx
Count.xlsx
I have three files, File1.xlsx, File2.xlsx, File3.xlsx
I would like to count on a certain colum on each files and output on Count.xlsx
Please advise.
file1.xlsx
file2.xlsx
file3.xlsx
Count.xlsx
Microsoft ExcelMicrosoft Office
Last Comment
Noah
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
The other way is to create a Pivot table which consolidates data from multiple workbooks. You will need the Power Query Add-in. If it is already installed, you can immediately follow the guide below.
You can download it here:
https://www.microsoft.com/en-sg/download/details.aspx?id=39379
Here is a guide and there is a tutorial video:
http://www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-different-workbooks/
You will also need to ensure that the data in the data files are already in tables.