This code should be copied into a cell in sheet1, then you can copy that
cell to all the other cells in sheet1


=IF(COUNT(Sheet2!$A$1:$A$500)<COLUMN();"";OFFSET(
Sheet2!$A$1;COUNT(Sheet2!$A$1:$A$500)-(COUNT(Sheet2!$A$1:$A$500)-COLUMN())-1;ROW()-1;1;1))

You can have as many columns in sheet2 that you like as long as you
have as many lines in sheet1 with the function in.
Right now it's limited to max 500 entries in each column i sheet 2.
The copying and pasting into cells in sheet1 should take about 15
seconds and then you're problem should be solved!

My first "Answer" post in this forum, previously I've only "asked"!:)

(I haven't tried this translated version but it works in swedish, if
you get any problems repost here!)


--
Ruatha
------------------------------------------------------------------------
Ruatha's Profile: http://www.excelforum.com/member.php...o&userid=31083
View this thread: http://www.excelforum.com/showthread...hreadid=551769