Filtering

  • Thread starter Thread starter Paul X
  • Start date Start date
P

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
 
Back
Top