Using a Worksheet Name in a Formula - XP or 2007
 

I've got a master worksheet containing data - with ten identical analysis
worksheets (at the moment, each with the name of a different Sales Rep.

I want each analysis worksheet to analyse the data purely for that Rep and
I'm trying to get to a solution where all my analysis formulae point to the
worksheet name to pick up the name of the Sales Rep - which then makes it
easy to add or change people.

Currently there is a column in the master worksheet which is a named range
called 'sales_rep' and my formulae are typically of the form.

=sumif(salesrep='JKS',salesvalue)

What I'd like to get to is

=sumif(salesrep=worksheetname,salesvalue)

Is there a way I can achieve this.

TIA

Rob

Using a Worksheet Name in a Formula - XP or 2007
 

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"RFJ" wrote in message
...
I've got a master worksheet containing data - with ten identical analysis
worksheets (at the moment, each with the name of a different Sales Rep.

I want each analysis worksheet to analyse the data purely for that Rep and
I'm trying to get to a solution where all my analysis formulae point to
the worksheet name to pick up the name of the Sales Rep - which then makes
it easy to add or change people.

Currently there is a column in the master worksheet which is a named range
called 'sales_rep' and my formulae are typically of the form.

=sumif(salesrep='JKS',salesvalue)

What I'd like to get to is

=sumif(salesrep=worksheetname,salesvalue)

Is there a way I can achieve this.

TIA

Rob