How to transfer table from one workbook to another?

		Microsoft Office Forums > Microsoft Excel > Excel
How to transfer table from one workbook to another?

FAQ

Thread Tools

Display Modes

02-23-2021, 02:32 AM

No.1

Windows Vista How to transfer table from one workbook to another?

Office 2007

Novice

Join Date: Aug 2013

Posts: 3

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

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