Quickly Combine Workbooks with XLhub:
- Consolidate scattered data
- Reduce time spent compiling data
- Accurately correlate data sets
- Protect and track data
Want to Combine Workbooks without Cut and Paste?
XLhub makes it easy to combine workbooks. First, create a hub for each source workbook you’d like to combine. Then, you can simply click the Save button to publish the latest data in each source workbook. Then in your destination workbook, you can simply click the Retrieve button for each hub source. Combine your workbooks with just a few clicks. Last minute changes are no longer a headache!
How to Combine Workbooks for the First Time
Once you’ve created a hub for each of the source workbook tabs you want to combine, you’re ready to combine the workbooks. First, open each source workbook and then click the Save button on the XLhub ribbon tab as shown in this screenshot:
After you click the Save button you will be prompted to describe the version of data you’re about to save. Enter your description and click the OK button.
In order to retrieve the data into your combined workbook, you’ll need to create tables which have the same table name as the source hub. For example, if you had a hub for a table named DemoTable in your source workbook, you would need to create a table called DemoTable in the destination workbook as well. To do this, click the cell where you would like the table to begin, and press CTRL+T. Press OK at the prompt:
Then click anywhere inside the newly formed table and select Table Tools from the ribbon menu then enter the Table Name in the field in the upper left corner (in the Properties section of the ribbon).
Now you can connect to the hub and retrieve data! Click the XLhub ribbon tab, then click Table Management, and Connect to Hub.
You will be prompted to confirm:
Now you can retrieve the data from your source workbook any time by opening the destination workbook and clicking Retrieve:
After clicking Retrieve, you will be prompted to choose a version and can simply select the latest version (in this case, the only version):
No More Combining Workbooks with Cut and Paste
Congratulations! You can end your days of combining workbooks through cut and paste. If you need to combine workbooks, you can use XLhub to do it quickly and easily.