S
scottwilsonx
Hi guys & girls, hope someone can help me with this quandry:
I have a row of data showing different months, eg: A2 contains "Apri
2004", A3 = "May 2004" etc
I want to include this text in a formula below that automatically goe
to the worksheet with that name (eg: April 2004) and takes the value i
the appropriate cells down the column.
For example, the formula would say ='April 2004'!$I7 and take the valu
in I7 from worksheet April 2004.
Is there a way of including an automatic reference to April 2004 etc i
a formulae.
Many thanks for any help.
Scott
I have a row of data showing different months, eg: A2 contains "Apri
2004", A3 = "May 2004" etc
I want to include this text in a formula below that automatically goe
to the worksheet with that name (eg: April 2004) and takes the value i
the appropriate cells down the column.
For example, the formula would say ='April 2004'!$I7 and take the valu
in I7 from worksheet April 2004.
Is there a way of including an automatic reference to April 2004 etc i
a formulae.
Many thanks for any help.
Scott