Join Excel Tables

M

MT MEX

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
 
M

MT MEX

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Excel worksheets 2
One pivot table for multiple worksheets/tabs 2
Combining 2 Tables Dynamically into third new Table 1
Pivot Table 1
Combine multiple ranges into one worksheet 1
Merging two similar worksheets 10
Combining Multiple Worksheets 4
How do I combine these columns into one? 2

Top