Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Excel Sheet combine question

Posted on 2007-04-11
6
959 Views
Last Modified: 2011-09-20
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
Comment
Question by:garrethmcadam
  • 4
  • 2
6 Comments
 
LVL 13

Expert Comment

by:adraughn
ID: 18891712
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
 

Author Comment

by:garrethmcadam
ID: 18891796
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
 
LVL 13

Expert Comment

by:adraughn
ID: 18892647
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 13

Accepted Solution

by:
adraughn earned 500 total points
ID: 18892662
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
 

Author Comment

by:garrethmcadam
ID: 18893365
Adria,
thank you
the little macro that you sent worked like a charm!!

0
 
LVL 13

Expert Comment

by:adraughn
ID: 18893375
you're welcome...
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question