Hyperlinks

[noy]

Hi

I've created a multisheet workbook for audit planning. Each worksheet has
the same 30 or so rows (subject of audit) and columns (weekly dates) and each
worksheet is named for each part of the business. Each cell has a drop down
list (the same for each sheet) to detail which of the 5 types of audit which
will be undertaken. It is therefore a planner so that each part of the
business knows what type of audit it will have each week.

I've created a front sheet for me so that I can keep an overview of the
audit schedule. It contains columns for part of the business , rows for
subject of the audits and then in each cell weekly dates from a drop down bar
which matches the weekly dates specified in the other worksheets.

Is there anyway of using a combination of lookups and hyperlinks so that if
I click on a cell in the front sheet it will take me to the same cell in the
relevant work sheet? e.g. I click on 12/10/08 cell from the 'fire' row for
the 'connections' business colmn and it then takes me to the connections
business worksheet into the cell determined by the row for fire row and the
column for 12/10/08.

If any knows one way or another I would be grateful for any help.

Thanks

 

[Pete_UK]

Yes, I think this could be done. Can you provide some details about
the layout of your sheets (with actual cell/column references), and
some examples of the data so I can model it first.

Pete

 

[noy]

Thanks Peter, what is the best way of getting the info to you? Would you need
a shortended version? (the full one is a bit big to e-mail) or would you need
me to post some info here?

Cheers

Noy

 

[Pete_UK]

Just post the descriptions here.

Pete

Thanks Peter, what is the best way of getting the info to you? Would you need
a shortended version? (the full one is a bit big to e-mail) or would you need
me to post some info here?

Cheers

Noy





- Show quoted text -