Thanks Roger, interesting approach to the problem. I would like to try
to build it so that all was needed was to enter the numbers each
month.
Marcelo,
I got your idea working really nicely - for one cell.
I can't see how you can copy that formula down a column so that it
automatically increments the row number as it goes down. I thought that
making the abs_num 3 or 4 should do that, but apparently not.
I've included a test spread sheet if anybody would be so kind to take a
look...
The indirect address function is in cell A7 of the May sheet.
What I would like to do is drag/copy that cell down to A10, then
duplicate the May sheet so all I have to change is the month number to
3 and the sheet title to June to set up the next month.
cheers
Axial
+-------------------------------------------------------------------+
|Filename: indirectaddress.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=5081 |
+-------------------------------------------------------------------+
--
axialtilt
------------------------------------------------------------------------
axialtilt's Profile:
http://www.excelforum.com/member.php...o&userid=36694
View this thread:
http://www.excelforum.com/showthread...hreadid=564245