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

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