you should use Data Validation feature.
select the range of cells where you want a drop down list.
go to menu Data Validation under Allow options select List and type
tax invoice numbers in Source field each seperated with a comma.
instead of typing invoice numbers in Source field, you can put a
reference of cells which contain invoice numbers.

hope this would solve your problem.
H&J Trans Wrote:
hi i was wondering how to make a drop down box so i can select a name
for
say my taxinvoices for my clients instead of having to type in the
whole
thing
thank you


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=572974