Filtering

[Paul X]

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

 

[Jacob Skaria]

You may refer

http://www.contextures.com/xlDataVal13.html
http://www.contextures.com/xlFunctions02.html

 

[Jacob Skaria]

You may refer

http://www.contextures.com/xlDataVal13.html
http://www.contextures.com/xlFunctions02.html