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

number	name	town	car
12wed	pete	a	red
13now	jane	b	purple
14men	fred	c	red
15kom	paul	d	blue

<TBODY>
</TBODY>

e.g. sheet 2

Number	pet	child
12wed	dog	1
13now	cat	0
14men	dog	3
15kom	hamster	6

<TBODY>
</TBODY>

e.g. combined sheet

Number	name	town	car	pet	child
12wed	pete	a	red	dog	1
13now	jane	b	purple	cat	0
14men	fred	c	red	dog	3
15kom	paul	d	blue	hamster	6

<TBODY>
</TBODY>

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.