ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Join Excel Tables (https://www.excelbanter.com/excel-discussion-misc-queries/204507-join-excel-tables.html)

MT MEX

Join Excel Tables
 
I have a worksheet that has tables from different plants in our company on
different worksheets. I want to join those tables into one combined table
for printing and review by my manager. I have been searching and cannot find
how to simply combine the tables into one. Everything seems to want to count
or match data not just combine the lists.

The table are matching with all the coloumn headings being exactly the same.

Can anyone help?

Thanks,
MT


Roger Govier[_3_]

Join Excel Tables
 
Hi

Take a look at Ron de Bruin's site
http://www.rondebruin.nl/copy2.htm

--
Regards
Roger Govier

"MT MEX" <MT wrote in message
...
I have a worksheet that has tables from different plants in our company on
different worksheets. I want to join those tables into one combined table
for printing and review by my manager. I have been searching and cannot
find
how to simply combine the tables into one. Everything seems to want to
count
or match data not just combine the lists.

The table are matching with all the coloumn headings being exactly the
same.

Can anyone help?

Thanks,
MT


MT MEX[_2_]

Join Excel Tables
 
Thanks Roger,
Quite a bit more complicated than I thought it would be. I don't do much
with code in MS office but understand the basics and may be able to make this
work for me.

Thanks again,
Mike


"Roger Govier" wrote:

Hi

Take a look at Ron de Bruin's site
http://www.rondebruin.nl/copy2.htm

--
Regards
Roger Govier

"MT MEX" <MT wrote in message
...
I have a worksheet that has tables from different plants in our company on
different worksheets. I want to join those tables into one combined table
for printing and review by my manager. I have been searching and cannot
find
how to simply combine the tables into one. Everything seems to want to
count
or match data not just combine the lists.

The table are matching with all the coloumn headings being exactly the
same.

Can anyone help?

Thanks,
MT



All times are GMT +1. The time now is 04:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com