Help with excel

Dunners101

I created a hyperlink in an empty slot on sheet1 which brings me to sheet2.In sheet two i want the user to be able to fill in a list of info and then i want the first line(name of list) to then appear in the slot in sheet1 that has the hyperlink.

Does anyone know how to do this?

Edser

Not too sure what exactly you want but try this..

Right click on the cell with the link and choose 'Edit Hyperlink'

In the 'Text to display' box put an equals sign (=) before the text which will probably look like 'Sheet2!A1', and click OK.

Click on the link, enter some data and go back to Sheet1.

Ed

Liam Byrne

Are you really putting an Excel spreadsheet on the web ?

Seth Brundle

You would need some VBA code triggered when the sheet or cell changes.

try this on a sub:

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim sht1, sht2 As String
    sht1 = "Sheet1"
    'if they change the value in B2...
    If Target.Address = "$B$2" Then
        ActiveWorkbook.Worksheets(sht1).Cells(2, 2).Formula = "=HYPERLINK(""" & ActiveWorkbook.Name & "#'" & ActiveSheet.Name & "'!B2"", """ & ActiveSheet.Cells(2, 2).Value & """)"
    End If
End Sub

Liam Byrne wrote: »

Are you really putting an Excel spreadsheet on the web ?

The OP never claimed to be planning on doing that!

edit: sorry Laim - I now remember that its in the Web Development & Design forum!