Hi All,
I have a spreadsheet that is running very slowly, the formula in column G and the array formulas in column J-M on Sheet - Route allocation are the main cause for is its poor performance
After the array's have finished working the end result is matching a person and a postcode that is available without duplicating, but these formulas only filter down which gives a match at 65%
Can VBA increase the speed and accuracy? I have attached the sheet and sample data
Sheet: Route Allocation
The Formula in Column G after dismissing certain pretext will look at Column J-M to find a matched name with out duplicating
Array Formulas in 'Route Allocation'J:M match Names against poscodes in sheet 'DA Avialble Coverage' this need to carry down to 750 rows
Sheet: DA Available Coverage
Data from 'DA Schedule' and 'Postcode by DA' are crossed reference to produce the data in 'DA Availabe Coverage'
Sheet: Postcode by DA
is a list of Names with postcodes each name can be listed 5 times
Column A Matches the name against the names in 'DA Schedule' and if an X is present in column I
Sheet: DA Schedule
A basic rota where X represent the day a person is working. Column I reveals who is working dependant on the day of the week
Sheet: Postcode by DSP
an information page that revelas who is covering postcodes
Any information would be grateful
Many Thanks
Danny
Bookmarks