I am working on a survey project which requires summing the data in the cells of 80 workbooks. Each workbook is one sheet and exactly the same format and layout. Each cell contains one number and no formula. Is there a way to shortcut the summation of these workbooks into a single report without having to cut and paste data from each sheet. The finished product is a summary report on all 80 workbooks.
Thank you.
Thank you.