| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks
Just post the descriptions here.
Pete On May 16, 11:41*am, noy wrote: 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" wrote: 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 On May 15, 10:52 am, noy wrote: 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 *- Hide quoted text - - Show quoted text - |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
| Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
| How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) | |||
| Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) | |||
| Using Hyperlinks | Excel Discussion (Misc queries) | |||
Threaded Mode
