Excel

Hi Jessie

Yes, you can consolidate from multiple workbooks. The easiest way to do this is to open all the workbooks, then when entering the data range simply select each workbook and the data to be consolidated in the same way you would if the data was in the workbook. Complete the process as normal