Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2017, 07:52 PM
naeemakhtar naeemakhtar is offline Combining multiple worksheets Windows 10 Combining multiple worksheets Office 2016
Novice
Combining multiple worksheets
 
Join Date: Apr 2016
Posts: 8
naeemakhtar is on a distinguished road
Default Combining multiple worksheets


I have a workbook that has 150 worksheets. Each worksheet has the same dimensions. I would like to combine each worksheet into one worksheet so there is only one workbook with one worksheet. Is there VBA script that would enable me to do this without manually going to each worksheet?
Reply With Quote
  #2  
Old 05-11-2017, 11:03 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Combining multiple worksheets Windows 7 64bit Combining multiple worksheets Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hi
this well known problem has been posted many times.
Before putting questions on free forums, you should first search the net and the forum to avoid members wasting their free time
It could have returned http://www.rondebruin.nl/win/addins/rdbmerge.htm
__________________
Using O365 v2503 - 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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining multiple worksheets Summarise information from multiple worksheets in multiple files alistair_ Excel Programming 5 04-10-2017 08:27 AM
Combining multiple worksheets combining cells with multiple choices H28Sailor Excel 1 01-13-2017 11:02 PM
Combining multiple worksheets Combining different worksheets into a single worksheet. jimmy2016 Excel Programming 4 10-15-2016 09:05 AM
Combining multiple worksheets Sum multiple worksheets and summary tab that would sum and count by rep name angie.chang Excel 1 05-16-2013 12:36 AM
Combining multiple bulleted lists TigerDroppings Word 2 03-09-2013 07:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:52 PM.


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