Hello guys,
I need your help. I have multiple excel sheets in one workbook. let says sheet1, sheet2 and so on... I also have one sheet "SNAGS"
I have three columns in each sheets except SNAGS Sheet(Description, Result and Notes)
example
Sheet 1
Description Result Notes
Is all OK Pass/Fail No New notes
Are you OK Pass/Fail Yes i am ok
so for each description user can either put pass or fail in result column. What i want to do is in the whole workbook if any cell has a value "Fail", the corresponding value of description cell should be copied in a sheet "SNAGS" which is already added. I have done this while using single sheet with a strange formula as below.
IFERROR(INDEX([values I want to return],SMALL(IF([Criteria Array]=[Criteria],ROW([Array I are looking up])),ROW()),1),"")
unfortunately to apply on whole workbook i will have to do VBA, which i am not able to. can some one please help me out here
I need your help. I have multiple excel sheets in one workbook. let says sheet1, sheet2 and so on... I also have one sheet "SNAGS"
I have three columns in each sheets except SNAGS Sheet(Description, Result and Notes)
example
Sheet 1
Description Result Notes
Is all OK Pass/Fail No New notes
Are you OK Pass/Fail Yes i am ok
so for each description user can either put pass or fail in result column. What i want to do is in the whole workbook if any cell has a value "Fail", the corresponding value of description cell should be copied in a sheet "SNAGS" which is already added. I have done this while using single sheet with a strange formula as below.
IFERROR(INDEX([values I want to return],SMALL(IF([Criteria Array]=[Criteria],ROW([Array I are looking up])),ROW()),1),"")
unfortunately to apply on whole workbook i will have to do VBA, which i am not able to. can some one please help me out here