I have created a transmittal log. I have the first worksheet named "FTM Log", in file "FTM Log". In which is a spread sheet containing information within each FTM. The following worksheets are numbered 1, 2, 3, 4 ect.(Relating to the FTM Number).
So far, i have pieced together, via the internet, the following hyperlink to take me to the worksheet: (A column is FTM Numbers)
=IF(A4="","",HYPERLINK(MID(CELL("filename",A4),SEARCH("[",CELL("filename",A4),1),SEARCH("]",CELL("filename",A4),1)-SEARCH("[",CELL("filename",A4),1)+1)&"'"&A4&"'!A1","To FTM"))
Problem...
Now, at FTM no. 650+, is there a way i can make a hyperlink from the worksheet back to the row/column that the FTM No. is located (so i dont get lost/ scroll down 600+ columns):
So far i have:
=VLOOKUP(E9,'FTM Log'!A3:L20,11,FALSE) // gives me the =Row within FTM Log
=VLOOKUP(E9,'FTM Log'!A3:L20,11,FALSE) // gives me the =Column within FTM Log
N6= =ADDRESS(row,column) // gives me the hypothetical address from the last two formulas
=HYPERLINK("[FTM Log]FTM Log!"&N6,"To Log") // hypothetically should return me to where i want, but it does not.
Can anyone help? Anything would help (im self taught so please go easy...)
Bookmarks