Hey there ,
I have built a simple drop down menu from 0-99 being selected from a
series of cells
Numbers!$A$1:$A$100
where A:1= 0
and a:100 = 99
and linked to cell using
'Bundled Systems'!$B$2
under the format control dialogue box.
HOWEVER
when the selected number from the drop down box is added to the
'Bundled Systems'!$B$2 field there is 1 added to it
That is
select 1 and return 2
select 10 return 11
etc
can anyone please let me know why this might be happening?
Thanks
--
Prellyan
------------------------------------------------------------------------
Prellyan's Profile:
http://www.excelforum.com/member.php...o&userid=30539
View this thread:
http://www.excelforum.com/showthread...hreadid=501944