Excel - My hyperlink in my excel worksheet is not working. Suggestions?

I am trying to create a hyperlink in my excel worksheet. I was able to
complete that task; however when I click on the hyperlink to open it, it
states " Cannot open the specified file".

  b replied...

Check the address in the hyperlink.  I occassionally have to revise mine
before they work.

The formula below works well, but I would like to add 2 modifications. = {MEDIAN(IF((Worksheet!C3:C1968 = Aggregate!A5)*(Worksheet!H3:H1968> 0), Worksheet!H3:H1968, ""))} 1. IF the value is blank how do I modify so it leaves is, "04-mar-01. This doesn't seem to work. Iadded this to the above *(Worksheet!G3:G1968> = 2005)*(Worksheet!G3:G1968< = 2008). . . Thanks. Excel Worksheet Discussions Microsoft Excel (1) Excel 2007 (1) SUMPRODUCT (1) Worksheet (1) MEDIAN (1) COUNT (1) TEXT (1) Wins (1) If you want an error trap pretty long unless you're using Excel 2007. In Excel 2007 only: = IFERROR(MEDIAN(IF((Worksheet!C3:C1968 = Aggregate!A5)*(Worksheet!H3:H1968> 0), Worksheet!H3:H1968)), "") In other versions: = IF

Search one worksheet to pull data into another worksheet Excel Worksheet 1: Name Acct Symbol Desc Qty Price Value Smith 614 FDRXX Fid Cash 33.66 42.85 12524.67 Jones 188 FCNTX Fid Contra 273.98 42.85 11739.96 Worksheet 2: I would like to first search Worksheet 1 for all instances of acct 188 which can appear anywhere in column 2, (in down to one result, and return Fid Contra 273.98, 42.85, and 11739.96. Worksheet 1 always has the same columns but in random order. It can be sorted but I should be using, it would be helpful. Thanks very much in advance. - Barbara Excel Worksheet Discussions Worksheet (1) INDEX (1) MATCH (1) ROW (1) MAX (1) Report (1) Hi, Enter this array

sub pu = F2 essere scritta molto meglio cos = EC: Public Sub m() Dim sh1 As Worksheet Dim sh2 As Worksheet Set sh1 = 3D ThisWorkbook.Worksheets("Foglio1") Set sh2 = 3D ThisWorkbook.Worksheets("Foglio2") sh1.Range("A1 un valore: Private Sub CommandButton1_Click() 'dichiaro le variabili Dim wk As Workbook Dim sh2 As Worksheet Dim lNuovaRiga As Long 'metto un riferimento al Workbook 'che contiene la macro Set wk fogli, quindi renderli visibili, sin qui inserisco le righe Private Sub CommandButton3_Click() Dim sh2 As Worksheet Set sh2 = 3D ThisWorkbook.Worksheets("Foglio2") sh2.Visible = 3D xlSheetVeryHidden = 3D -1 Set sh2 = 3D due pulsanti: Private Sub CommandButton1_Click() 'dichiaro le variabili Dim wk As Workbook Dim sh As Worksheet 'metto un riferimento al workbook 'che contiene il codice Set wk = ThisWorkbook With wk 'ciclo End Sub Private Sub CommandButton2_Click() 'dichiaro le variabili Dim wk As Workbook Dim sh As Worksheet 'metto un riferimento al workbook 'che contiene il codice Set wk = ThisWorkbook With wk 'ciclo due cose: Private Sub CommandButton3_Click() 'dichiaro le variabili Dim wk As Workbook Dim sh As Worksheet 'metto un riferimento al workbook 'che contiene il codice Set wk = ThisWorkbook With wk 'ciclo dichiaro le variabili visibili 'da tutta la UserForm Private wk As Workbook Private sh1 As Worksheet Private sh2 As Worksheet Private sh3 As Worksheet Private Sub Frame2_Click() End Sub 'questo ? l

after this one) sub limits() Dim Mix_Size As Integer Mix_Size = Range("Mix_Size").Value Sheets("Data worksheet").Select Sheets("data worksheet").unprotect "1dickson" Dim numone As Double Dim numtwo As Double Dim numthree As Double Dim AA500") numnineteen = Sheets("jmf changes").Range("W500") numtwenty = Sheets("jmf changes").Range("D500") Sheets("Data worksheet").Cells(8, 3) = numone Sheets("data worksheet").Cells(32, 7) = numtwo Sheets("Data Worksheet").Cells(31, 7) = numthree Sheets("Data Worksheet").Cells(30, 7) = numfour Sheets("Data Worksheet").Cells(29, 7) = numfive Sheets("Data Worksheet").Cells(28, 7) = numsix Sheets("Data Worksheet").Cells(27, 7) = numseven Sheets("Data Worksheet").Cells

ELIZABETH 61 COLLINS LAURA A 61 PARKER KATHLEEN 61 WILLIAMS LATOYA 61 ROBINSON JOHNNE 61 WALTERS TOMMIE 61 BUCHLER JUSTIN 61 PATTEN CURTIS L 61 I WANT TO BE ABLE TO 61 TO 68, HOW MANY NAMES ARE WITHIN THE RANGE OF LAST NAME LEWIS TO WALTERS? Excel Worksheet Discussions SUMPRODUCT (1) COUNT (1) Timmons (1) Sean (1) KATHLEEN (1) CALLAWAY (1) CAMPBELL (1) MARQUITA (1) = SUMPRODUCT(- -($A$2:$A$5000> = "Lewis"), - -($A$2:$A$5000< = "Walters"), - -($B$2L$B$5000> = 61), - -($B$2L$B$5000< = 68)) All ranges must be the