I have one sheet that has a list that contains some text that has hyperlinks and then I use lookup ona different sheet, but when the text is displayed onthe second sheet the hyperlink is not there. Is there a way of keeping the hyperlink on the second sheet. The hyperlink uses ...
User has Excel 2002 SP3 His workbook has multiple links to other workbooks that are password protected. He wants to know if there is a way to incorporate the password into the link. Any ideas?
I have a need to do what I believe is called a two dimensional search. I want to populate a cell with the contents of a cell that exists at the intersection of a row and column each of which contains a known value.
I need to filter the results of my array. I have a column "DOI" that is a date and I need the array to only display the blank/null values into my new sheet. ie. IF(DOI=Null, DOI) I also need to be able to bring over the Incident and owner columns only if