I have called data from another tab with a combo box by doing the
following:

First - name the range of the data on the other tab. This can be done
with the shortcut on the toolbar (left of the formula bar) or by going
to Insert - Name - Define
next - in the combobox where it asks for the input range, enter
"=namedrange"

Hope this helps.


--
barrfly

Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141
View this thread: http://www.excelforum.com/showthread...hreadid=392336