Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
Hello I'm trying to automate my regular excel journal form. I want to set up a drop down filter that can look up data from another spreadsheet. eg sheet 1 filter arrow select account code 5555, the 5555 code will bo on a list in sheet 2. Then in the next cell to acc code 5555 in sheet 1 is a VLOOKUP function which is linked to this cell and looks up the name of this account, from sheet 2 I hop you can understand the question. Thank you Best regards Paul |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
You may refer
http://www.contextures.com/xlDataVal13.html http://www.contextures.com/xlFunctions02.html -- If this post helps click Yes --------------- Jacob Skaria "Paul X" wrote: Hello I'm trying to automate my regular excel journal form. I want to set up a drop down filter that can look up data from another spreadsheet. eg sheet 1 filter arrow select account code 5555, the 5555 code will bo on a list in sheet 2. Then in the next cell to acc code 5555 in sheet 1 is a VLOOKUP function which is linked to this cell and looks up the name of this account, from sheet 2 I hop you can understand the question. Thank you Best regards Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering | Excel Discussion (Misc queries) | |||
filtering | Excel Discussion (Misc queries) | |||
Filtering ? | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
Filtering | Excel Discussion (Misc queries) |