Hi,

I am trying to put a series of hyperlinks on worksheet #1 that acts as an index.

I want the hyperlink to jump to the next unused cell in column C on, for example, a worksheet called "COKE & COAL" The user can then put the next row of data in.

I have got as far as

=HYPERLINK("#COKE!"&ADDRESS(MATCH(REPT("z",255),COKE!C:C),3),LOOKUP(REPT("z",255),COKE!C:C))

Qn 1. How do I make it go plus one row down?

Qn 2. Can I use the insert hyperlink function and put the formula in the cell reference? This will enable me to label the hyperlink cell COKE & COAL.

Qn 3. Also found that the above formula does not allow for characters and spaces in the sheet name - thefore the truncation to COKE. Can I have COKE & COAL? Just easier to use COKE??

Thanks,


Ben.