DYNAMIC LISTBOX
May be
define A1 as low
define A2 as high
list box refers to
=OFFSET(Sheet2!$B$1,low-1,0,high-low+1,1)
"daphoenix" wrote in message
...
I would like to know if there is a way to have a listbox return only values
that meet two critera.
Like if Cell A1 = 5 and Cell A2 = 20, i would like only to return the
values
located in a diffrent sheet(column B) between rows 5 and 20. Then those
values would be put in the ListBox.
Thanks
|