Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-23-2021, 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; 02-23-2021 at 02:34 AM. Reason: Fix typo
Reply With Quote
  #2  
Old 02-27-2021, 10:50 AM
wiganken wiganken is offline How to transfer table from one workbook to another? Windows 10 How to transfer table from one workbook to another? Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

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.
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

All times are GMT -7. The time now is 07:16 AM.


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