Solved

Excel Sheet combine question

Posted on 2007-04-11
6
956 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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

760 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now