Auto populate hyperlink

Ok, i'm guessing it's not an easy fix. I have found the following code which is doing partly what i want:

=HYPERLINK("mailto:your.email@domain.com?subject="&"Overtime request for "&A6,"Apply" )

A6 = the date. The row it must select from is row A however, i would like it to select cell 6 because i clicked on G6 to apply. If i click on G7 then i would like it to populate with the date from A7. Hope that makes sense.

=HYPERLINK("mailto:your.email@domain.com?subject="&"Overtime request for "&INDIRECT("A"&COLUMN()),"Apply" )

Hi Gak, thanks very much for the reply,

I copied and pasted that formula in, its definitely doing almost what i want, however whichever row i put the code in it always uses A7 as the subject date. Not sure why as theres no direct reference to it, i'm obviously doing something wrong

Can you upload a sample file?

Sorry, new to the forums, how do i upload a sample file?


Book1.JPG

Click on Go Advanced at bottom right of where you enter a reply, then click on the paperclip. Then add, select, upload and post.

Ok, hopefully this is what you need.

Oops. My bad. Try

Formula:

=HYPERLINK("mailto:your.email@domain.com?subject="&"Overtime request for "&INDIRECT("A"&ROW()),"Apply" )

(have changed COLUMN (which was always column G - ie coulmn 7) to ROW, which takes the row number).

That does it... brilliant, thank you very much indeed.

If your issue has been resolved mark the thread as SOLVED.

If I have been helpful please click on Add Reputation (* in bottom left of my posts).