excel

[H&J Trans]

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]

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.