philscrase
Board Regular
- Joined
- Feb 1, 2007
- Messages
- 142
I currently have a table which has been extracted from another source. It is full of random information, some complete, some incomplete ....
My horizontal headers are: Code, Description, Area, Cost.
'Code' contains the fields A1, A2, A3, A4, A5, A6, A7, B1, B2, B4, B11, E56, F76, G121.
'Description' is just text which is unimportant.
'Area' contains names of Area (Area1 Area2 Area3 etc)
'Cost' - a random amount in £'s
Areas are listed from 1 to 57 (Area1 through to Area57) - Now the annoying part is that not ALL areas have a value for the 'Code'. For example, where most have something for codes A1 through to G121 there are some Areas whom dont have a value like for code A6, B4, E56 etc. Therefore the line doesnt exist (There is no complete line with the code, desc, Area and cost - the line will just be non existent) I hope i have explained that ok(ish).
What i want to do is to create a table with the codes across the top, Area names down the side (left) and have some kind of function that will match the code with the Area and put the cost in the relevant box. where there is no entry then it would just be blank.
Is there anything that will read a vertical and a horizontal point and find that value if there is one?
I'm not after a great deal of work as i'd imagine it could be quite complicated, but if you could point me in the right direction i can get on with investigating that.
Any help is much appreciated.
I have a complete set of vertical headers which are . Now for some 'Areas' i have info, for others i dont, and it is very messy.
My horizontal headers are: Code, Description, Area, Cost.
'Code' contains the fields A1, A2, A3, A4, A5, A6, A7, B1, B2, B4, B11, E56, F76, G121.
'Description' is just text which is unimportant.
'Area' contains names of Area (Area1 Area2 Area3 etc)
'Cost' - a random amount in £'s
Areas are listed from 1 to 57 (Area1 through to Area57) - Now the annoying part is that not ALL areas have a value for the 'Code'. For example, where most have something for codes A1 through to G121 there are some Areas whom dont have a value like for code A6, B4, E56 etc. Therefore the line doesnt exist (There is no complete line with the code, desc, Area and cost - the line will just be non existent) I hope i have explained that ok(ish).
What i want to do is to create a table with the codes across the top, Area names down the side (left) and have some kind of function that will match the code with the Area and put the cost in the relevant box. where there is no entry then it would just be blank.
Is there anything that will read a vertical and a horizontal point and find that value if there is one?
I'm not after a great deal of work as i'd imagine it could be quite complicated, but if you could point me in the right direction i can get on with investigating that.
Any help is much appreciated.
I have a complete set of vertical headers which are . Now for some 'Areas' i have info, for others i dont, and it is very messy.