Hi!

Use the native Excel capability to make one cell equal another.

So:If you have 20 rows on sheet1, running to 15 columns (A:O)

Put in Sheet3, A1 ='Sheet1'!A1. Copy across 15 columns.
Copy that row down 20 rows.

Now for Sheet2.

Leave enough space between the two tables to accommodate new rows if
any will be needed.

Then, say at A30 put ='Sheet2'!A1: copy across and down as before.

Done.

Don't know why you would want to do it, but there it is.

Alf


--
AlfD
------------------------------------------------------------------------
AlfD's Profile: http://www.excelforum.com/member.php...fo&userid=4785
View this thread: http://www.excelforum.com/showthread...hreadid=354135