Auto populate hyperlink

=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