Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Excel Sheet combine question

I have an excel workbook with 10 sheets of data. The data is uniform in all sheets, i.e. they have the same column heading and data type in each heading. Is there an easy way that i can combine them all into one sheet without having to cut and paste from one into the other?
0
garrethmcadam
Asked:
garrethmcadam
  • 4
  • 2
1 Solution
 
adraughnCommented:
There isn't an EASY way that I know of. But if you post more details (columns used, etc.) we can write code to do it.

How many sheets are we talking about? How many rows of data? Keep in mind, you are limited to 65,536 rows.

adria
0
 
garrethmcadamAuthor Commented:
Hello,
I thought there maybe an easier solution than coding.
It seems like something you would expect to be available in the merge or combine functionality.
These are my column headings
the number of rows would never exceed the limit you posted in the last thread.

idnumber      firstName      lastName      hireDate      postalCode      jobTitle      department      facility      countryDivision
0
 
adraughnCommented:
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
adraughnCommented:
or this previous post by byundt...

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_20924061.html?qid=20924061


let me know if it doesn't work for you.

adria
0
 
garrethmcadamAuthor Commented:
Adria,
thank you
the little macro that you sent worked like a charm!!

0
 
adraughnCommented:
you're welcome...
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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