View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kat Kat is offline
external usenet poster
 
Posts: 56
Default Looking up data from another sheet

Hi, I'm very confused!
I'm used to using Access databases and often create tables and queries for a
combo box in a field so I can select the appropraite data.

I know this is possible in Excel to an extent too and would love to know how
to do it. I've been trying all morning and getting nowhere.

For example in Sheet One I will have the headings Issue Title, Opened By,
Date Opened, Due Date, Prioirty, Status and Description

In Sheet Two I would like lists of options to put in Opened By, Priority and
Status

Please help!