Hiro 714
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.