#1
|
|||
|
|||
How to transfer table from one workbook to another?
I have five excel workbooks and each of them has one worksheet with a table in it.
I want to transfer the tables from the worksheets of the other four workbooks onto the worksheet of the first workbook, say, with the tables separate by one row from each other after the transfer. How can I do that without having to open all these five workbooks and doing copy and paste multiple times? Any idea would be much appreciated. Last edited by No.1; 02-23-2021 at 02:34 AM. Reason: Fix typo |
#2
|
|||
|
|||
I don't think you can do it any other way because only you knows the order in which you want to copy/paste the 4 tables into workbook 1. Not something that can be shortened.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Transfer data to another book based on the active cell - Specific ranges only | ganesang | Excel Programming | 6 | 03-27-2020 05:28 PM |
Excel found unreadable content in file.xls. Do you want to recover the content of this workbook? | Sanfran | Excel | 2 | 10-21-2014 12:09 AM |
Cell Background Color: Base it on Content of Cell? | tatihulot | Excel | 4 | 08-14-2013 03:24 PM |
How can I delete the content of a cell in column if the cell value is more than 1000? | Learner7 | Excel | 2 | 06-27-2011 05:44 AM |
macro to transfer data from one workbook to another workbook | virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |