In the case of dealing with inexperienced users, the entire sequence could
be set up to run by macro(s), thereby insuring that the steps taken would be
the same each time, and in accordance with protocol.

Vaya con Dios,
Chuck, CABGx3
"jane" wrote in message
...
The user did that but their manager prefers a formula because many users
will
be accessing this report on a regular basis but thank you for the
suggestion.

"CLR" wrote:

Assuming you have a column that indicates the qualification of =5%, I
would
just do Data Filter AutoFilter , and filter on that column, then
Copy
Paste the data to wherever you want.........

Vaya con Dios,
Chuck, CABGx3





"jane" wrote:

I have to produce a recap that shows any store that is producing =5%.

For the recap, I need to return the store #, store name, actual %
achieved
that is 5% or greater.

The recap is referencing another tab that has the store # in col A,
store
nmae in column B, and performance data in column I.

thank you in advance! jane