worksheet plus one
I am trying to build a monthly worksheet that imports data from cells on
adjacent worksheets. Right now, I copy the worksheet, then have to manually
type in ('August 06'!G2,'Sept 06'!G2,'Oct 06'!G2). What I would like to do
is set it up so that it will take the current month G2, then add 1 and
subtract 1 to get the adjacent month's data so that it always shows a
rolling three month.
I've not been able to find a function that allows "worksheet+1"
"worksheet-1". Is this possible?
|