I have 250 rows and about 40 columns in sheet 'master'. I want rows with specific criteria from a certain column to be mirrored in different sheets. So I have sub-sheets that have certain criteria from one column. Is this an INDEX? INDEX(MATCH(?
Can't seem to find a formula that fits the need.