Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-31-2015, 08:23 PM
Alaska1 Alaska1 is offline Merging several worksheets into one exel file Windows 7 64bit Merging several worksheets into one exel file Office 2007
Advanced Beginner
Merging several worksheets into one exel file
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default Merging several worksheets into one exel file

I have several tabs from different files that I want to merge into one excel file. What is the best way to merge the tabs into one document?
Reply With Quote
  #2  
Old 08-01-2015, 12:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Merging several worksheets into one exel file Windows 7 64bit Merging several worksheets into one exel file Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,506
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Through this add-in.
No worries, the author is a well-known MVP. Code is also available for merging
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 08-01-2015, 03:55 PM
Alaska1 Alaska1 is offline Merging several worksheets into one exel file Windows 7 64bit Merging several worksheets into one exel file Office 2007
Advanced Beginner
Merging several worksheets into one exel file
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
Through this add-in.
No worries, the author is a well-known MVP. Code is also available for merging
Thank you for your help.
Reply With Quote
  #4  
Old 08-03-2015, 08:38 AM
Chancy Chancy is offline Merging several worksheets into one exel file Windows 7 64bit Merging several worksheets into one exel file Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2015
Posts: 32
Chancy is on a distinguished road
Default

Quote:
Originally Posted by Alaska1 View Post
I have several tabs from different files that I want to merge into one excel file. What is the best way to merge the tabs into one document?
You could left-click on the tab you want to merge, and then Ctrl-left-click all the tabs relevant in that workbook, then right-click and choose "copy" or "move", and then navigate via the drop-down box to the file you want them all to reside in. That can be one of your existing files, or you can choose "new" and move them all there. You would have to do this with each workbook that has tabs you need.

This can be a little complicated if the file types are different, i.e., .xls versus .xlsx, but is completely smooth if the types are the same.
Reply With Quote
  #5  
Old 08-04-2015, 08:20 AM
Alaska1 Alaska1 is offline Merging several worksheets into one exel file Windows 7 64bit Merging several worksheets into one exel file Office 2007
Advanced Beginner
Merging several worksheets into one exel file
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default

Thank you for your reply.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging several worksheets into one exel file How to import data from Word to Exel? minhvu315 Word 1 12-16-2014 08:04 AM
Merging several worksheets into one exel file I need an index file containing the names of all the worksheets in a workbook. retiredstuart Excel 3 09-12-2014 06:26 AM
Merging several worksheets into one exel file Merging excel values to text file daymaker Excel 18 10-24-2013 12:45 AM
Saving in Exel does not work Peter Balsiger Excel 3 09-18-2013 02:45 AM
Merging several worksheets into one exel file Merging two Word files with one file having a text box Timothy2001 Word 3 01-23-2011 07:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:03 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