<div>
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.<br />
<br />
How many sheets are we talking about? How many rows of data? Keep in mind, you are limited to 65,536 rows.<br />
<br />
adria
</div>


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

<div>
Hello, <br />
I thought there maybe an easier solution than coding.<br />
It seems like something you would expect to be available in the merge or combine functionality.<br />
These are my column headings<br />
the number of rows would never exceed the limit you posted in the last thread.<br />
<br />
idnumber &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;firstName &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;lastName &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;hireDate &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;postalCode &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;jobTitle &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;department &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;facility &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;countryDivision<br />

</div>


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


<div>
you could try this...<br />
<br />
<a href="http://www.digdb.com/excel_add_ins/combine_append_tables_sheets_files/" rel="ugc">http://www.digdb.com/excel_add_ins/combine_append_tables_sheets_files/</a>
</div>


you could try this...

http://www.digdb.com/excel_add_ins/combine_append_tables_sheets_files/ [http://www.digdb.com/excel_add_ins/combine_append_tables_sheets_files/]

<div>
Adria,<br />
thank you <br />
the little macro that you sent worked like a charm!!<br />
<br />

</div>


Adria,
thank you
the little macro that you sent worked like a charm!!



<div>
<div class="content wysiwyg-content">
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?
</div>
</div>


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?

Excel Sheet combine question

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.