Hey everyone,
I am trying to create a workbook where several cells on a sheet have hyperlinks to another cell in a different cell. For example I have a table with various projects in column A (currently 10 different projects), column B contains an estimated date of completion , column C contains an adjusted date, E:BD is representative on each of the 52 workweeks, and in Column D I am using the auto sum function to show the total days we are ahead of or behind schedule. In column C am using, =[@[Date of Completion]]+SUM(E3:BD3), then all I have to do is input a number in one of the cells representing a workweek to adjust the date of completion if we experience delay or are ahead of schedule. My customer would like this sheet to be an overview then have each cell that represents a workweek and link to a cell in a second sheet that contains a detailed description of the progress made that week. The second sheet contains the project name in column A and the workweeks in column range B:BA. Does anyone know of a way to quickly create the hyperlinks? I tried using the following formula =HYPERLINK("#Comments!B3", "0"). This presented several different problems; First, I lose the ability to enter a number in the cell without editing the formula, it also renders the other formulas useless, and finally, it will not automatically change the formula, so it is still relevant when copied to adjacent cells.
I am trying to create a workbook where several cells on a sheet have hyperlinks to another cell in a different cell. For example I have a table with various projects in column A (currently 10 different projects), column B contains an estimated date of completion , column C contains an adjusted date, E:BD is representative on each of the 52 workweeks, and in Column D I am using the auto sum function to show the total days we are ahead of or behind schedule. In column C am using, =[@[Date of Completion]]+SUM(E3:BD3), then all I have to do is input a number in one of the cells representing a workweek to adjust the date of completion if we experience delay or are ahead of schedule. My customer would like this sheet to be an overview then have each cell that represents a workweek and link to a cell in a second sheet that contains a detailed description of the progress made that week. The second sheet contains the project name in column A and the workweeks in column range B:BA. Does anyone know of a way to quickly create the hyperlinks? I tried using the following formula =HYPERLINK("#Comments!B3", "0"). This presented several different problems; First, I lose the ability to enter a number in the cell without editing the formula, it also renders the other formulas useless, and finally, it will not automatically change the formula, so it is still relevant when copied to adjacent cells.
