Fill Handle to increment sheet numbers

Hello Guys,

I have a problem for which i am not finding the solution.

I have the following formula:

Please Login or Register  to view this content.

I would like to use the fill handle to increment the sheet number by 1 as i drag it, as i need to go up to sheet CHHeb90.

However, the fill handle does not increment the sheet number by 1. My sheets are named CHHeb1, CHHeb2 etc.. up to CHHeb90.

Would anyone know a solution around this problem? For the moment, i have to manually change the sheet number by increasing it by one for each cell but this is extremenly time consuming.

thanks a lot in advance

=IF(indirect("CHHeb"&row(a1)&"!b11")="";"";indirect("CHHeb"&row(a1)&"!b11"))

Is that what you want?

Regards

Dav

Hello Dav,

thanks for replying. In fact i have a sheet that recaps the value of the same cell from each sheet.

that is cell B11. I got 90 sheets named CHHEb1 to CHHEB 90.

in cell A1 on the recap sheet, i put the formula =IF(CHHeb1!$B11="";"";CHHeb1!$B11)

i would like to drag this cell from A1 to A90. however, in A2 the formula should equal =IF(CHHeb2!$B11="";"";CHHeb2!$B11) and so on...

However, when i use the handle box to drag the formula from A1 to A90, the sheet number does not change. it stays CHHeb1..

Is there a way to make the CHHeb increment by 1 in the formula as it is dragged along? i did not manage to use the formula you provided.. maybe i am not using it properly