I thought that there was a feature in Excel that would combine all the data from several worksheets into a summary worksheet. The summary would have all the columns and rows that were unique.
Example would be that there were quarterly sales on individual worksheets with the sales persons names. When the worksheets are combined, there would be each quarter and each sales person’s name, even if they appeared only on one quarter’s worksheet.
I thought that the feature was “combine” but that seems to only work for one left column and one heading row. We are looking for a way to easily copy all the data from several workbooks. Copy and Paste, of course, works, but we were hoping to automate the process for monthly updates.
Is a macro the only way to get this combined workbook?
