I have workbook with multiple sheets that are all formatted identically. Basically, each page contains individual employee data.
I created a summary sheet that captures essential data from the each worksheet.
Everything works great on the summary sheet but I cannot determine how to change the sheet reference "S1, S2, S3..." so that I can simply drag the formula down a row and have the formulas change.
Here's the formula...
{=IFERROR(INDEX('S1'!$F$3:$F$17,MATCH(FALSE,ISBLANK('S1'!$F$3:$F$17),0)),"")}
Any help is greatly appreciated.
TIA
I created a summary sheet that captures essential data from the each worksheet.
Everything works great on the summary sheet but I cannot determine how to change the sheet reference "S1, S2, S3..." so that I can simply drag the formula down a row and have the formulas change.
Here's the formula...
{=IFERROR(INDEX('S1'!$F$3:$F$17,MATCH(FALSE,ISBLANK('S1'!$F$3:$F$17),0)),"")}
Any help is greatly appreciated.
TIA