| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming | |||
Threaded Mode
