A
Andy
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
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