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
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
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.
Originally Posted by H&J Trans
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks