Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down lists and autofill
Hi, I am setting up a workbook to handle the payment of invoices that I get
from various suppliers. On one sheet (within the same workbook) I have set up details of supplier name, account number, settlement discount etc. On the main sheet, you can choose supplier for a particular invoice from a drop-down list referencing the 'supplier' sheet, but is it then possible, on choosing the supplier, to autofill adjacent cells on the main sheet with the other info? Hope that makes sense. Adrian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill new row in lists | New Users to Excel | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Autofill/Autocomplete Prediction PullDown Lists | Excel Discussion (Misc queries) | |||
Autofill lists | Excel Discussion (Misc queries) |