Solved

Excel Sheet combine question

Posted on 2007-04-11
6
957 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Hard coding time and date into Excel 2 30
Auto populate in Cascade dropdown 3 27
TSQL previous 5 24
CUT & PASTE VALUES IN EXCEL USING MACRO -- SPECIFIC CELLS 27 0
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

911 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

22 Experts available now in Live!

Get 1:1 Help Now