Hi,
I have a huge amount of data in one sheet spanning 8 coloumns the first
of which runs from 0 - 11 to the bottem (each number corresponding with
multiple rows).
On anouther sheet I have a listbox with the values 1 - 11 with a cell
reference.
How do I get the listbox to recall the data ranges that correspond with
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 statements
may be the way to go?
Cheers
--
Hru48
------------------------------------------------------------------------
Hru48's Profile:
http://www.excelforum.com/member.php...o&userid=24895
View this thread:
http://www.excelforum.com/showthread...hreadid=384325