mdfreeman
New Member
I am using the Compare and Merge function in Excel 2010 just like it is described on this page: https://office.microsoft.com/en-ca/excel-help/merge-copies-of-a-shared-workbook-HP010177169.aspx
The issue is that I cannot merge more than one file at a time into the original shared file as per the directions - "To merge the workbook with multiple copies of the shared workbook at the same time, hold down CTRL or SHIFT and click their file names, and then click OK."
Question: Does anyone know why? I need the data and formulas to populate back into the original file vs. just merging files through a VBA tool.
The issue is that I cannot merge more than one file at a time into the original shared file as per the directions - "To merge the workbook with multiple copies of the shared workbook at the same time, hold down CTRL or SHIFT and click their file names, and then click OK."
Question: Does anyone know why? I need the data and formulas to populate back into the original file vs. just merging files through a VBA tool.