I have been given a project which I have absolutely no idea how to go about it!
My company is nationwide and is organised on a district to regional basis. Every month there is a sql query thrown into excel which lists in Cols A-D
- business code AB123 (A = programme type, Bxx=Region, the final x=district)
- subhead code A01-A12 e.g. A01 is Salary
- monetary value
- Name of district
The end result should be a number of district tables (which will feed into regional tables, then national tables) with a list of programmes on the left hand side, along the top is listed the subheads, then there will be some calculated fields - these would contain the financial details of each district per programme per subhead.
Problem - all of it! Esp the fact that the managers want it future proofed so that any new districts will be pulled out as well (e.g. someone may set up AB1237 (7 being the district number). As far as i can make out the maximum possible disticts a region may have is 27 variations
AB122x, AB123x, AB124x
If anyone can even point me in a direction i will be happy!
e.g.Can you use vlookup to look for a range of values for each district?
apologies and thanks in advance!!
My company is nationwide and is organised on a district to regional basis. Every month there is a sql query thrown into excel which lists in Cols A-D
- business code AB123 (A = programme type, Bxx=Region, the final x=district)
- subhead code A01-A12 e.g. A01 is Salary
- monetary value
- Name of district
The end result should be a number of district tables (which will feed into regional tables, then national tables) with a list of programmes on the left hand side, along the top is listed the subheads, then there will be some calculated fields - these would contain the financial details of each district per programme per subhead.
Problem - all of it! Esp the fact that the managers want it future proofed so that any new districts will be pulled out as well (e.g. someone may set up AB1237 (7 being the district number). As far as i can make out the maximum possible disticts a region may have is 27 variations
AB122x, AB123x, AB124x
If anyone can even point me in a direction i will be happy!
e.g.Can you use vlookup to look for a range of values for each district?
apologies and thanks in advance!!