VBA code that searches multiple worksheets in a workbk and returns specific data to sheet

This follows on from my previous post:

http://www.excelforum.com/excel-prog...ml#post4073991

Skywriter, your code does exactly what I want and asked for, bang on and fairly easier for my novice skillset. I just need help to adding a few extra layers to it. At the moment it's searching for array headers as the values are under headers, but now in addition to that I need it to return specific values which have no headers from the matched sheets. e.g. in addition, return data from B12 if F12 = Fail

I forum mod skywriter greatly assisted me in creating an array find macro that returned data from various sheets in a workbook.

I've been struggling add code for the search function to return additional values from the sheet if they met a certain criteria. My Almost working code is in attached workbook and below:

Please Login or Register  to view this content.

Many Thanks....

Awesome!!!! Dude you Rock!

Just out of interest, how long did it take you roughly to do this, took me 2 hours and I still failed...
Ah well..I'm still learning..

Rep added

Ahh, I see... well Excelforum is definitely the place for practice as there's load of newbie's like me. I was a good cobol programmer 17 yrs ago myself..but stopped and took a career detour...so due to necessity I've had to fast track learning Excel and recently started Access to build a work tool...

Thanks again...much appreciated.