Hopefully I can get the question clearly across.

I have a workbook with two worksheets.

One displays projects and the other displays resources.

On each worksheet the first viewable 30 or so rows gives a summary, projects
and resources. Now below each summary I have a detail of each project and
what resources are working on it, as well as each resource and what projects
they are on. Are you still with me?

Now everywhere there is a project or resource listed I have a link to that
corresponding section on either worksheet.

The problem I am having is when I jump between worksheets. When I click a
link it goes to the link but then I have to scroll down to get the full view
of the data related. Logically I understand why it would do this but I'm
wondering if there is a easy fix, before I mess around with 100+ links? Is it
just a matter of redirecting the link so that "aim" lower in the range of
data?




--
Jack of all trades... master of none..