V
vinu
Hi,
I'm just preparing a summery sheet for an work book that contains more
then 60sheets (date wise)
In Column B7 - Sheet Name(i.e. 26th April
In Column C7 to G7 - Array Formula (i.e. {='26th April'!C21:G21})
In Column J7 to N7 - Array Formula (i.e. {='26th April'!J20:N20})
Is there any way to change the formula in a way to just drag down the
formula by referring B cell instead of typing the sheet name in the
formula.
Thanks in anticipation....
Vinu.
I'm just preparing a summery sheet for an work book that contains more
then 60sheets (date wise)
In Column B7 - Sheet Name(i.e. 26th April
In Column C7 to G7 - Array Formula (i.e. {='26th April'!C21:G21})
In Column J7 to N7 - Array Formula (i.e. {='26th April'!J20:N20})
Is there any way to change the formula in a way to just drag down the
formula by referring B cell instead of typing the sheet name in the
formula.
Thanks in anticipation....
Vinu.