View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Using HLookup for DV lists

Keep an open mind, Andy. What works for one scenario
may not work, or be practical in another.

From the sounds of it, think Debra's page
would have relevance to what you seek to do:
http://www.contextures.com/xlDataVal02.html
Excel -- Data Validation -- Create Dependent Lists
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Andy" wrote:
I'm building a reporting template in a workbook on one tab "Backend" I hold
all the DV List values Customer, Sector, Region, Month etc

The next tab "IT Open Issues Log" is the actual report.
In IT Open Issues Log!D4 They will define the Sector using a DV list, the
values of which are on =Backend!$H$2:$H$7

when they are adding line items they will select the Customer affected again
using a DV list they do this in IT Open Issues Log!B7 for the first item and
the Values come from =Backend!$A$2:$A$131, The Next Item would be in B8, B9,
B10 etc etc

What I would like to do is to have IT Open Issues Log!B* DV Lists filtered
by Sector, the Customer list has a Sector listed against it in
=Backend!$B$2:$B$131, e.g If it is the Automotive Sector Report then only
the Automotive Customer should show in the DV List.

Am i using the right solution or is there a smarter way of doing this?

I hope that makes sense??

If they would let me create a database i'd be happier, but they'd die if
they couldn't use Office Products to do management reporting