Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 148
  • Last Modified:

Combine x number of excel worksheets in into one sheet on the same workbook

Hi,

I have an excel workbook with 50+ worksheets.
I need to consolidate all those 50+ sheets into another sheet on the same workbook.
Something like Sheet 2 copied data under sheet 1, then sheet 3 data copied under sheet 2, etc.

More sheets will be added into the workbook. The amount of sheets will not be static.
Therefore the solution for this probably has to be programmatically looping through all existing sheets and copying the data.

I have found solutions in here but not with an unknown number of sheets.

Please if you can provide me with a detailed solution i would appreciate it. (Partial solution or logic for the solution would not be enough for me)


Thank you

Carlos M
0
carlosmonte
Asked:
carlosmonte
1 Solution
 
Saqib Husain, SyedEngineerCommented:
Upload a sample for testing.
0
 
ProfessorJimJamCommented:
There is a free merge add-in  developed by my friend Ron you can download
It does the job as you described
http://www.rondebruin.nl/win/addins/rdbmerge.htm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now