Hey I have the following formula that looks for all the data with a certain month. But it only looks at one tab. now the tabs names will vary and will be added over time. is there a way to check all tabs, if not then what is my other option? thanx in advance
Quote:
{=INDEX('0504-0611'!$E$3:$H$119,SMALL(IF(TEXT('0504-0611'!$J$3:$J$119,"mmmm")=$A$1,ROW('0504-0611'!$J$3:$J$119)-MIN(ROW('0504-0611'!$J$3:$J$119))+1, ""), ROW(A1)),COLUMN(A1))}
Bookmarks