Simon said:
Glad we could be of help!
If your query has been solved please take a moment to let us and
eveyone else know by going to Thread Tools>Mark Thread Solved,shown by
this icon 29
+-------------------------------------------------------------------+
|Filename: marksolved.gif |
|Download:
http://www.thecodecage.com/attachment.php?attachmentid=29|
+-------------------------------------------------------------------+
Just thought I would let you know. I couldn't get the Combo box to work
properly (wouldn't copy to any other cells ). I therefore came across
avideo on YouTube that showed how to make a Data\Validation\Drop down
box. My brain fart than cleared and I remembered that was what my drop
down box was. I than checked to see what my range of cells was and I
just increased the range from 12 cells to 17 and it works fine.
Only think I can't understand is that the range that it references to is
a blank range of cells (=#A$230:$A$242). However; when I make changes in
a defined range (Builderslist)(='reference Tables'!$A$21:$D$37); which
is in a complete different area of the spreadsheet; these changes are
reflected in the drop down list.
Comment?