=ADDRESS(1, 3, 1,, "sheet1")
returns
SHEET1.$C$1
=INDIRECT(ADDRESS(1, 3, 1,, "sheet1"))
returns whatever is stored in the cell referenced by SHEET1.$C$1
On 09/28/2013 11:30 AM, John Meyer wrote:
I have a spreadsheet with a number of worksheets. The first worksheet
has the bonuses for employees in this format
ID, Sales Agent, Sales For Date, Bonus for Date, Sales for Date(N),
Bonus For Date (N). . .
The rest of the spreadsheets are each named for the date of sales that
they contain. They are in the same format as the column header for
Sales For Date.
I set up each row like this
ID static, Agent name static,
=COUNTIF(*staticdateworksheet*!ColumnWithIDFirstRow:ColumnWithIDNthRow,Firstcolumnrowiamin),BonusCalculation
What I'd like to do is change that formula around to resolve the sheet
name by the first row of the salescount ID (i.e. if It's 9-27-2013 it
would pull up 9-27-2013, 9-28-2013, etc.). Is this possible? It's
not a pressing issue, I'd just like to see if it could be done.
Thanks.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
