Thank you, yes! - each sheet is called EMP1, EMP2 etc up to 40Hi @Matt_Straya,
I think in your formula only EMP4, EMP5....... this portion is changing?
=IFERROR("'C:\Users\winterm1\Documents\Server down\[Training Risk Register_v004b.xlsm]"&Sheet6!$B7&"'!$V$3","")
Thanks S - no that didnt work. the original formula is =IFERROR('EMP4'!$K$2,"") - Id like to copy this formula down the column and the EMP4 to change to EMP5 and so onHi @Matt_Straya,
Please check the below formula is working or not in cell F7.
Thanks Pecoflyer! works a treat using this: =IFERROR(INDIRECT("'EMP"&ROW()-10&"'!$K$2"),"")If the first occurence on the formula is in row 1 try =IFERROR(INDIRECT("'EMP"&row()+3&"'!$K$2","")
Otherwise adapt the ROW().. part to the row you are starting in.
For example if you start in row 10 use row()-6, etc...