Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invoice spreadsheet
I have inherited a spreadsheet where items are cut and pasted on to the
invoice. I'd like to improve this by using drop down lists. Going across i have the following column headings Quantity - Description - Sales Code - Price - Line Total What I want is to be able to pick the description and have the sales code and price (where applicable) filled in automatically. can anyone give me some pointers as the best way to proceed. Cheers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invoice spreadsheet
Build a list of the values you want in each drop down.
Click in the cell you want the Drop Down to appear in, then go to: From the menu select, Data, Validation, and List. Refer the list to the cells you've already populated. -- Dave Eade EPCS Ltd www.EPCS.me.uk "gibbylinks" wrote: I have inherited a spreadsheet where items are cut and pasted on to the invoice. I'd like to improve this by using drop down lists. Going across i have the following column headings Quantity - Description - Sales Code - Price - Line Total What I want is to be able to pick the description and have the sales code and price (where applicable) filled in automatically. can anyone give me some pointers as the best way to proceed. Cheers |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invoice spreadsheet
Thanks Dave,
I have all the information there. I have my dropdown list for description, but how do I get the sales_code and prices to appear in their relevant columns when I select the description from the dropdown list ? "Dave Eade" wrote: Build a list of the values you want in each drop down. Click in the cell you want the Drop Down to appear in, then go to: From the menu select, Data, Validation, and List. Refer the list to the cells you've already populated. -- Dave Eade EPCS Ltd www.EPCS.me.uk "gibbylinks" wrote: I have inherited a spreadsheet where items are cut and pasted on to the invoice. I'd like to improve this by using drop down lists. Going across i have the following column headings Quantity - Description - Sales Code - Price - Line Total What I want is to be able to pick the description and have the sales code and price (where applicable) filled in automatically. can anyone give me some pointers as the best way to proceed. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Invoice/Inventory spreadsheet | Excel Discussion (Misc queries) | |||
looking for an one invoice on an extra large spreadsheet | Excel Discussion (Misc queries) | |||
how do I create an invoice from a spreadsheet | New Users to Excel | |||
LINK EXCEL INVOICE TO A SPREADSHEET | Links and Linking in Excel | |||
Excel Spreadsheet and Invoice Forms | Excel Discussion (Misc queries) |