I've got a table with columns of Sales Reps names and their Total Sales.

I want to create a new worksheet that has two tables - one of the names of
the Reps with the highest sales figures and one with the lowest. I want to
be able to vary those figures - so will need to keep them as constants -
with range names, say, 'High' and 'Low'.

If possible I want the table of the highes figures above the one with the
lowest - so I can print off onto one piece of paper.

How do I do it, bearing in mind the number of rows will change depending on
the values I put if for 'High' and 'Low'

TIA

Rather than have a variable number of rows for different values of
High and Low, it might be better to show the Top-10 highest and the
Top-10 lowest.

Hope this helps.

Pete

On May 12, 8:59*am, "BRob"
wrote:
I've got a table with columns of Sales Reps names and their Total Sales.

I want to create a new worksheet that has two tables - one of the names of
the Reps with the highest sales figures and one with the lowest. I want to
be able to vary those figures - so will need to keep them as constants -
with range names, say, 'High' and 'Low'.

If possible I want the table of the highes figures above the one with the
lowest - so I can print off onto one piece of paper.

How do I do it, bearing in mind the number of rows will change depending on
the values I put if for 'High' and 'Low'

TIA

Tx for the suggestion.

However, I do need to flex the value that I look up - rather than the number
of records to report.



"Pete_UK" wrote in message
...
Rather than have a variable number of rows for different values of
High and Low, it might be better to show the Top-10 highest and the
Top-10 lowest.

Hope this helps.

Pete

On May 12, 8:59 am, "BRob"
wrote:
I've got a table with columns of Sales Reps names and their Total Sales.

I want to create a new worksheet that has two tables - one of the names of
the Reps with the highest sales figures and one with the lowest. I want to
be able to vary those figures - so will need to keep them as constants -
with range names, say, 'High' and 'Low'.

If possible I want the table of the highes figures above the one with the
lowest - so I can print off onto one piece of paper.

How do I do it, bearing in mind the number of rows will change depending
on
the values I put if for 'High' and 'Low'

TIA