L
lindan8r
Hello,
I have created an Excel database to track documents. I am trying to create
a "master" Excel workbook that only I can edit, and put an identical workbook
on the server for my co-workers to look at but not edit (i.e., mess up).
However, I want my co-workers to be able to filter the necessary information,
re-arrange it, etc., to suit their specific needs.
To keep the information in Workbook1 and Workbook2 identical, I've linked
the cells from WB2 to WB1, so that when I make changes to WB1, the
information is updated in WB2 automatically. The formula I use for that is:
=[Workbook1.xls]TabName!A1
The problem that I'm having is that I also want one of the cells in each row
to contain a hyperlink to a Word document. However, when I create the
hyperlink, the hyperlink is associated with that specific CELL, so that when
the columns are filtered, alphabetized, etc., the hyperlink showing "Document
1" will actually open up "Document 65" because it is associated with the CELL
when I created the hyperlink.
I hope that makes sense. I guess the bottom line to my question is...Is
there any way to make a hyperlink move with the text, rather than stay within
a specific cell?
Or, does anyone have any suggestions on a better way to set this up?
Thanks in advance!
Linda
I have created an Excel database to track documents. I am trying to create
a "master" Excel workbook that only I can edit, and put an identical workbook
on the server for my co-workers to look at but not edit (i.e., mess up).
However, I want my co-workers to be able to filter the necessary information,
re-arrange it, etc., to suit their specific needs.
To keep the information in Workbook1 and Workbook2 identical, I've linked
the cells from WB2 to WB1, so that when I make changes to WB1, the
information is updated in WB2 automatically. The formula I use for that is:
=[Workbook1.xls]TabName!A1
The problem that I'm having is that I also want one of the cells in each row
to contain a hyperlink to a Word document. However, when I create the
hyperlink, the hyperlink is associated with that specific CELL, so that when
the columns are filtered, alphabetized, etc., the hyperlink showing "Document
1" will actually open up "Document 65" because it is associated with the CELL
when I created the hyperlink.
I hope that makes sense. I guess the bottom line to my question is...Is
there any way to make a hyperlink move with the text, rather than stay within
a specific cell?
Or, does anyone have any suggestions on a better way to set this up?
Thanks in advance!
Linda