R
RFJ
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
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