Special Request

[magmike]

I am using Excel 2007.

I receive a report on a weekly basis that includes information on appr
800 different construction projects. The sheet is organized by Stage
of the process. The eight stages are listed at the top and color coded
with cell shading, and then a freeze frame is applied. The listings of
each project follows for about 800 rows, and is sorted by the stage
each project is in. Each stage has a header.

Typically I will do a CTRL + F to search for the address of the
project. However, once I find it, I must scroll up for 100 or so rows
to find out which stage it is listed under. I am hoping there is a way
that once the listing is found, somehow, above the frozen frame or
someother way, the stage is selected or identified in alt text or
something.

Any ideas?

Thanks in advance for you help!
magmike

 

[Don Guillett]

I am using Excel 2007.

I receive a report on a weekly basis that includes information on appr
800 different construction projects. The sheet is organized by Stage
of the process. The eight stages are listed at the top and color coded
with cell shading, and then a freeze frame is applied. The listings of
each project follows for about 800 rows, and is sorted by the stage
each project is in. Each stage has a header.

Typically I will do a CTRL + F to search for the address of the
project. However, once I find it, I must scroll up for 100 or so rows
to find out which stage it is listed under. I am hoping there is a way
that once the listing is found, somehow, above the frozen frame or
someother way, the stage is selected or identified in alt text or
something.

Any ideas?

Thanks in advance for you help!
magmike

It would help to see a file so

Send your file with a complete explanation and before/after examples
to dguillett1 @gmail.com

 

[Don Guillett]

I am using Excel 2007.

I receive a report on a weekly basis that includes information on appr
800 different construction projects. The sheet is organized by Stage
of the process. The eight stages are listed at the top and color coded
with cell shading, and then a freeze frame is applied. The listings of
each project follows for about 800 rows, and is sorted by the stage
each project is in. Each stage has a header.

Typically I will do a CTRL + F to search for the address of the
project. However, once I find it, I must scroll up for 100 or so rows
to find out which stage it is listed under. I am hoping there is a way
that once the listing is found, somehow, above the frozen frame or
someother way, the stage is selected or identified in alt text or
something.

Any ideas?

Thanks in advance for you help!
magmike

 

[Victor Delta]

I am using Excel 2007.

I receive a report on a weekly basis that includes information on appr
800 different construction projects. The sheet is organized by Stage
of the process. The eight stages are listed at the top and color coded
with cell shading, and then a freeze frame is applied. The listings of
each project follows for about 800 rows, and is sorted by the stage
each project is in. Each stage has a header.

Typically I will do a CTRL + F to search for the address of the
project. However, once I find it, I must scroll up for 100 or so rows
to find out which stage it is listed under. I am hoping there is a way
that once the listing is found, somehow, above the frozen frame or
someother way, the stage is selected or identified in alt text or
something.

Any ideas?

Thanks in advance for you help!
magmike

Are you saying that if you scroll down the sheet the freeze pane leaves the
project stages shown at the top but if you use ctrl+f the freeze pane
disappears?

If so, that's odd. If not, suggest you reset the freeze pane to leave the
top row in place before searching for the project address.

Hope this helps.

V