Quote:
Originally Posted by Spencer101
I do this type of thing on a daily basis as part of my job, and with much larger data sets than you have there. Thing is, without a "unique identifier" you're gonna have a very hard time data matching.
Are there no other references available on the data? "Job number", "Date raised" etc. ?
|
The only thing unique across all sheets is the school code.
The 'Maintenance Data' sheet is very detailed & accurate with all works broken down into locations/element/sub-element/revised descriptions etc - I know because I compiled it myself from condition surveys carried out in 2008.
The 'PM Orders' sheets have just been pulled from reports off a system with very open input methods so not broken down at all and just a mass of info in a cell.