Forum Discussion
Consolidating data from multiple worksheets
Note: I'm a Mac user but could use a PC if needed. I am trying to analyze patient satisfaction surveys and have been given an excel file. Unfortunately, the way the program exports results is not ...
I need to consolidate from several workbooks into one. data is in same place with same headings in each workbook. Can someone send me a formula?
see below sites, hope it helps..
https://www.ablebits.com/office-addins-blog/2015/12/08/excel-reference-another-sheet-workbook/
https://support.office.com/en-us/article/create-an-external-reference-link-to-a-cell-range-in-another-workbook-c98d1803-dd75-4668-ac6a-d7cca2a9b95f
https://www.ablebits.com/office-addins-blog/2015/12/08/excel-reference-another-sheet-workbook/
https://support.office.com/en-us/article/create-an-external-reference-link-to-a-cell-range-in-another-workbook-c98d1803-dd75-4668-ac6a-d7cca2a9b95f