To anybody that can help please
I have built a spreadsheet which shows whether my companys drivers are re-fulling there vehicles.
I am struggling to make a front sheet to collate all my data into one simple view.
There are only 3 tabs,
Unfuelled Check NEW.xls
On The front page tab i need a forumla that populates names from B13 downwards.
The data is being collected from the Fueling Tab..... this is were it gets complicated.....
I need data from the Driver Coloumn for a week so ( W9:W40, AB9:AB40, AG9:AG40, AQ9:AQ40, AV9:AV40, BA9:BA40)
I do not want to include "NOT USED"
I would also only like the drivers names to be populated if the reason code is "02:Driver Error" from cells X9:X40, AC9:AC40, AH9:AH40, AR9:AR40, AW9:AW40, BB9:BB40,
There is a fleet tab with all the drivers names.
Is this just too complicated or can it be done???
If anyone has a way of simplifying this I would be very Grateful.
Thanks
Majort
Bookmarks