Hello all from rainy Prague
Could you possibly help me as I have the following formula and =[CAM_MUST_HAVE_KPIs_2019_General_Staffing_CZECH_REP_w39.xlsx]w5!$BZ$17 and need that w5 stays changing to w6 and then to w7 etc. ... not sure how to do it. w5, w6, w7, etc. being names of different sheets in in the file. Is it called indirect linking?
Many thanks for all ideas in advance!
Kat