is it possible to specify a range using offset's? as each month the columns required will change, hence i require a less explicit way (than A29:A34, for example) to tell it where to copy and paste from and to.
does that make sense?
Thanks
Printable View
is it possible to specify a range using offset's? as each month the columns required will change, hence i require a less explicit way (than A29:A34, for example) to tell it where to copy and paste from and to.
does that make sense?
Thanks
of course you can:
[VBA]
=OFFSET(A1,1,MONTH(NOW()))
[/VBA]
Above will give you value of cell A1 plus one row and nine columns ("J2").
Adjust as you like.
=A29:INDEX(A29:A41,MONTH(TODAY()))
non-volatile
Thanks very much