Put formual in B2 and C2 and fill down till 32 row

[HaroonSid]

hi,
i want put this formula in B2 =

Please Login or Register  to view this content.

And fill down this formula to row 32 in sequel number

b2 = =IFERROR('Z:\42766\Jan 2 Dec 2014\1.12.16\[1.6.17.XLSB]TOTAL BC VC'!R2C4,"""")
b3 = =IFERROR('Z:\42766\Jan 2 Dec 2014\1.12.16\[2.6.17.XLSB]TOTAL BC VC'!R2C4,"""")
b4 = =IFERROR('Z:\42766\Jan 2 Dec 2014\1.12.16\[3.6.17.XLSB]TOTAL BC VC'!R2C4,"""")
b5 = =IFERROR('Z:\42766\Jan 2 Dec 2014\1.12.16\[4.6.17.XLSB]TOTAL BC VC'!R2C4,"""")
b6 = =IFERROR('Z:\42766\Jan 2 Dec 2014\1.12.16\[5.6.17.XLSB]TOTAL BC VC'!R2C4,"""")
b7 = =IFERROR('Z:\42766\Jan 2 Dec 2014\1.12.16\[6.6.17.XLSB]TOTAL BC VC'!R2C4,"""")
and ..........continue till rows 32
b 32 = =IFERROR('Z:\42766\Jan 2 Dec 2014\1.12.16\[31.6.17.XLSB]TOTAL BC VC'!R2C4,"""")

and same with C2
i want put this formula in B2 =

Please Login or Register  to view this content.

c2 = "=IF(RC[-1]="""","""",COUNTA('Z:\42766\Jan 2 Dec 2014\1.12.16\[1.6.17.XLSB]TOTAL BC VC'!R4C3:R100C3))"
c3 = "=IF(RC[-1]="""","""",COUNTA('Z:\42766\Jan 2 Dec 2014\1.12.16\[2.6.17.XLSB]TOTAL BC VC'!R4C3:R100C3))"
c4 = "=IF(RC[-1]="""","""",COUNTA('Z:\42766\Jan 2 Dec 2014\1.12.16\[3.6.17.XLSB]TOTAL BC VC'!R4C3:R100C3))"
c5 = "=IF(RC[-1]="""","""",COUNTA('Z:\42766\Jan 2 Dec 2014\1.12.16\[4.6.17.XLSB]TOTAL BC VC'!R4C3:R100C3))"
c6 = "=IF(RC[-1]="""","""",COUNTA('Z:\42766\Jan 2 Dec 2014\1.12.16\[5.6.17.XLSB]TOTAL BC VC'!R4C3:R100C3))"
c7 = "=IF(RC[-1]="""","""",COUNTA('Z:\42766\Jan 2 Dec 2014\1.12.16\[6.6.17.XLSB]TOTAL BC VC'!R4C3:R100C3))"
and ..............continue till rows 32
c32 = "=IF(RC[-1]="""","""",COUNTA('Z:\42766\Jan 2 Dec 2014\1.12.16\[31.6.17.XLSB]TOTAL BC VC'!R4C3:R100C3))"

[buran]

Please Login or Register  to view this content.

[HaroonSid]

Thank you
its working as i wanted