Are the columns in Sheet2 fixed in size or do the size variate? (I e are
there always a fixed number of entries?)

Do you want the answer as a function in the cells in sheet 1 or as a
VBA macro code?
A function I can propably do but VBA code I can't, someone else can
though.


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