merge two sheets into one sheet from multiple books variable ranges

[Freshbambam]

Hello,

I have a number of workbooks each with two pages/tabs.

On each of the tabs the data is identified by a unique number. Each tab has the same number of data items, located in different ranges. (e.g. sheet 1 A13:R23, sheet 2 C7:E17, in this case 10 items, in another book there may be 100 on each sheet).

I would like to be able to merge the work books so that all of the data appears on one sheet side by side. e.g. sheet 1, row 13 has the data from sheet 2 row 7 from the example above). Look at the tables below to get an idea of what I mean.

e.g. sheet1

[TABLE="class: grid, width: 500, align: left"]
<TBODY>[TR]
[TD]number[/TD]
[TD]name[/TD]
[TD]town[/TD]
[TD]car[/TD]
[/TR]
[TR]
[TD]12wed[/TD]
[TD]pete[/TD]
[TD]a[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]13now[/TD]
[TD]jane[/TD]
[TD]b[/TD]
[TD]purple[/TD]
[/TR]
[TR]
[TD]14men[/TD]
[TD]fred[/TD]
[TD]c[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]15kom[/TD]
[TD]paul[/TD]
[TD]d[/TD]
[TD]blue[/TD]
[/TR]
</TBODY>[/TABLE]










e.g. sheet 2

[TABLE="class: grid, width: 500, align: left"]
<TBODY>[TR]
[TD]Number[/TD]
[TD]pet[/TD]
[TD]child[/TD]
[/TR]
[TR]
[TD]12wed[/TD]
[TD]dog[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]13now[/TD]
[TD]cat[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]14men[/TD]
[TD]dog[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]15kom[/TD]
[TD]hamster[/TD]
[TD]6[/TD]
[/TR]
</TBODY>[/TABLE]










e.g. combined sheet

[TABLE="class: grid, width: 400, align: left"]
<TBODY>[TR]
[TD]Number[/TD]
[TD]name[/TD]
[TD]town[/TD]
[TD]car[/TD]
[TD]pet[/TD]
[TD]child[/TD]
[/TR]
[TR]
[TD]12wed[/TD]
[TD]pete[/TD]
[TD]a[/TD]
[TD]red[/TD]
[TD]dog[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]13now[/TD]
[TD]jane[/TD]
[TD]b[/TD]
[TD]purple[/TD]
[TD]cat[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]14men[/TD]
[TD]fred[/TD]
[TD]c[/TD]
[TD]red[/TD]
[TD]dog[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]15kom[/TD]
[TD]paul[/TD]
[TD]d[/TD]
[TD]blue[/TD]
[TD]hamster[/TD]
[TD]6[/TD]
[/TR]
</TBODY>[/TABLE]









Can merge single sheets multiple books thanks to previous posts on this forum, having difficulty defining ranges and "adding" them together.

All files will be stored in one directory.

Anyone help?

Cheers,

Fresh

 

[Freshbambam]

Anyone?

 

[Freshbambam]

Bounce.

Please help?

 

[Freshbambam]

this is useless.