excel
 

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

excel
 

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