VBA Question

[Mike Davis 1977]

i have a problem not even sure it can be fixed

i have a large (ish) workbook i use for scheduling tasks to multiple engineers across the weeks

Each Tab in book is 1 week and then Engineers Down Left Side and Days Of the week across the top (image of 1 week is uploaded to show this

what i require if possible is a VBA code that will pull Specific data from each Tab onto 1 New Tab to Show Tasks that Fail.

you will see in the image that each set of cells showing 1 task has a Status (drop down) "Not Started, Complete, Failed, Rolled" depending on the status at the end of each day

the Failed Tasks are the ones i need to have a Auto List Created as the Office Staff cannot Keep this up to date (to much work apparently)

1, is this possible?
2, can anyone assist me with this ?

in the Image you can see 1 Gang For the Week directly below this is the same Cell Layout Repeated another 8 times as i have 8 gangs to Field Daily

Any Further Info you Need to assist with my Query please ask and ill do my best to reply swiftly

 

[ExcelGzh]

Mike Davis 1977

It would be possible to write vba code that searches the sheet looking for occurrences of the status "failed", so the question is - what data do you want returned when it finds a failed job?

 

[Mike Davis 1977]

@ExcelGzh thank you for your reply but I ended up completely re making the whole sheet in such a way I could use basic =filter function to return the desired information (im getting better by the day with excel) incredible tool

 

[ExcelGzh]

OK. Good luck with it all.