Hi,

I have a huge amount of data in one sheet spanning 8 coloumns the firs
of which runs from 0 - 11 to the bottem (each number corresponding wit
multiple rows).

On anouther sheet I have a listbox with the values 1 - 11 with a cel
reference.

How do I get the listbox to recall the data ranges that correspond wit
the '1 - 11' and place that data one the first sheet by the list box.

I have tried with lookup tables but I am thinking that case statement
may be the way to go?

Cheer

--
Hru4
-----------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...fo&userid=2489
View this thread: http://www.excelforum.com/showthread.php?threadid=38432