Using HLookup for DV lists
 

Hi

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

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

Using HLookup for DV lists
 

Max,

Fantastic thank you, solution is great, I had a hunch i'd need to reaarange
the data.

I'll look around to see if there is a slicker way of setting up the lists
but for now it does the job exactly as i need.

5 star for coming back so quickly
p.s
I totally agree with you What works in one Scenario won't work in another.



"Max" wrote:

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

Using HLookup for DV lists
 

Welcome, Andy.
All the best.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Andy" wrote in message
...
Max,

Fantastic thank you, solution is great, I had a hunch i'd need to
reaarange
the data.

I'll look around to see if there is a slicker way of setting up the lists
but for now it does the job exactly as i need.

5 star for coming back so quickly
p.s
I totally agree with you What works in one Scenario won't work in another.