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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down lists and autofill
Use VLOOKUP().
See Excel Help -- Gary''s Student - gsnu200795 "Adrian Bamford" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down lists and autofill
=VLOOKUP(A1,SHEET2!$A25:E700,COLUMNS($A:B),0)
This formula assumes this : A1 is where you have your dropdownlist (adjust as needed) SHEET2!A25$:E700data place in sheet 2(or any name you want)between A25 and E700 ( again adjust as needed). COLUMNS($A:B),)0 the only variable will be "B" and that's the cell you are going to put the formula to VLOOKUP in the original working sheet. Then change it to "C" when you put the same formula in C in the original working sheet, ETC. and copy down. Post back if any questions. "Adrian Bamford" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down lists and autofill
As others have suggested, you can use a VLOOKUP formula to pull the
supplier data. There's an example order form here that might help you: http://www.contextures.com/xlOrderForm01.html Adrian Bamford wrote: 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 -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
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) |