I am trying to find a way to hyperlink to a cell within a worksheet that is referenced from another worksheet but within the same workbook. I’m going to need a formula to do this for I must first check the first column of the sourced worksheet for it is the only column in which there will be data stored. This is a date column but all I want to find out is what the next available row is so I can use that reference when sourcing the appropriate cell within my hyperlink.
For instance:
A B C D
1 01/25 4.856
2 02/01 3.254
3 03/25 3264
4 06/15 3.265
5 08/17 3.25
6
7
8
I need to hyperlink to column C but jump to row 6 for that is the next available row to be written to.
I’m thinking that I can use row A for it will always be populated whereas the other rows only one of the columns may contain data. Is this possible? Can you help me come up with a way to identify the next available row to write data?
Any help would be greatly appreciated..
Mike
Bookmarks