K
kronik
I've been searching for about an hour now and have yet to find the
solution to my problem.
I have 15 workbooks, i.e. Inventory 1, Inventory 2, Inventory 3.
In each of these workbooks there are 5 sheets, Desktops, Laptops,
Printers, Monitors, Hubs.
On each sheet, the categories are applicable to the inventory.
Essentially, these 15 workbooks are identical in format, with different
data.
I would like to merge all of the workbooks either into one workbook
with 5 sheets that has all of the data from all of the workbooks.. or
an Access database with all of the data from all of the workbooks.
These are workbooks on Sharepoint that are constantly changing so
copy/pastespecial does not apply here. Someone help me, please.
solution to my problem.
I have 15 workbooks, i.e. Inventory 1, Inventory 2, Inventory 3.
In each of these workbooks there are 5 sheets, Desktops, Laptops,
Printers, Monitors, Hubs.
On each sheet, the categories are applicable to the inventory.
Essentially, these 15 workbooks are identical in format, with different
data.
I would like to merge all of the workbooks either into one workbook
with 5 sheets that has all of the data from all of the workbooks.. or
an Access database with all of the data from all of the workbooks.
These are workbooks on Sharepoint that are constantly changing so
copy/pastespecial does not apply here. Someone help me, please.