Thread: Filtering
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul X Paul X is offline
external usenet poster
 
Posts: 1
Default 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