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

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

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

How many rows of data need to be searched and approximately how many stores
will meet this condition?

If there are 1000's of rows of data and 100's of srores that will meet the
condition then filtering is by far your best solution.

If there are only a few hundred (or less) rows of data and maybe 10's of
stores that will meet the condition then a formula *may* be acceptable.

--
Biff
Microsoft Excel MVP


"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

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