Excel Sheets lookup/macro
Closed
EMoney
Posts
1
Registration date
Wednesday May 27, 2009
Status
Member
Last seen
May 28, 2009
-
May 28, 2009 at 11:41 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 28, 2009 at 10:23 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 28, 2009 at 10:23 PM
Related:
- Excel Sheets lookup/macro
- Spell number in excel without macro - Guide
- Macros in excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
- Excel date format dd.mm.yyyy - Guide
- How to screenshot excel sheet - Guide
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
165
May 28, 2009 at 10:23 PM
May 28, 2009 at 10:23 PM
1. You can just enter your sheet name and then Insert Hyper link on them
Insert > Hyperlink > book Mark> Select your desired Sheet
2. Write hyperlink Code like you are in Sheet1 then Write in Cell A2=hyperlink("[book1.xls]sheet2!A1," Go To "&Sheet2!A1)
3. I"ve made a macro and you can run it in Sheet1 then in your Column A all the sheets names will appear ..... In column B you can use my method 2 by giving reference
After Running this macro in Sheet1 Cell B1 put this formula B1=HYPERLINK("[BOOK1.XLS]"&A1&"!A1","Go to Sheet") and drag it down ....... please note "Go to Sheet" is a friendly name and you can ignore it .....
Insert > Hyperlink > book Mark> Select your desired Sheet
2. Write hyperlink Code like you are in Sheet1 then Write in Cell A2=hyperlink("[book1.xls]sheet2!A1," Go To "&Sheet2!A1)
3. I"ve made a macro and you can run it in Sheet1 then in your Column A all the sheets names will appear ..... In column B you can use my method 2 by giving reference
Sub LISTSHEETS()
Dim ws As Worksheet
Dim x As Integer
x = 1
Sheets("Sheet1").Range("A:A").Clear
For Each ws In Worksheets
Sheets("Sheet1").Cells(x, 1) = ws.Name
x = x + 1
Next ws
End Sub
After Running this macro in Sheet1 Cell B1 put this formula B1=HYPERLINK("[BOOK1.XLS]"&A1&"!A1","Go to Sheet") and drag it down ....... please note "Go to Sheet" is a friendly name and you can ignore it .....
