Hi all
I am using the following function to return a value form another worksheet. There will be there will be X20 versions of the same thing repaeted X52 times, as it is part of a calculations page returning values for various things over a year.
to speed up my writing and help allow for further development I would like to replace the worksheet reference "1!" , "2!" , "3!" ...etc with an indirect which refers to a cells on the same page listing all the worksheets.
=SUMIF('1'!$AX$10:$AX$2500,$E11,'1'!$AY$10:$AY$2500) where '1!' is the first sheet, I also have 2-20
(INDIRECT($F11&"!")) I tried inserting this to replace '1!' but I only get errors?
Any help would be great thanks
I am using the following function to return a value form another worksheet. There will be there will be X20 versions of the same thing repaeted X52 times, as it is part of a calculations page returning values for various things over a year.
to speed up my writing and help allow for further development I would like to replace the worksheet reference "1!" , "2!" , "3!" ...etc with an indirect which refers to a cells on the same page listing all the worksheets.
=SUMIF('1'!$AX$10:$AX$2500,$E11,'1'!$AY$10:$AY$2500) where '1!' is the first sheet, I also have 2-20
(INDIRECT($F11&"!")) I tried inserting this to replace '1!' but I only get errors?
Any help would be great thanks
