Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old Yesterday, 02:32 AM
No.1 No.1 is offline How to transfer table from one workbook to another? Windows Vista How to transfer table from one workbook to another? Office 2007
Novice
How to transfer table from one workbook to another?
 
Join Date: Aug 2013
Posts: 3
No.1 is on a distinguished road
Default 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; Yesterday at 02:34 AM. Reason: Fix typo
Reply With Quote
Reply

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
How to transfer table from one workbook to another? 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
How to transfer table from one workbook to another? 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
How to transfer table from one workbook to another? macro to transfer data from one workbook to another workbook virsojour Excel Programming 5 02-01-2011 08:58 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 04:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft