View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brock Angelo Brock Angelo is offline
external usenet poster
 
Posts: 1
Default 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?