Drag to fill Hyperlink help

New Contributor

Hello, I have made a hyperlink to email once a project has been completed.  It works how I would like it but the issue is I cannot figure out how to drag to fill.  I do not want to manually enter in the correct cells for 1000 lines.  


Here is the formula =HYPERLINK("mailto:"&$AA$3&"?subject="&$AB$3&"&cc="&$AC$3&"&body="&$AD$3,"Send email")


I would like to drag down and autofill up to line 1003 


Any help would be appreciated, thank you. 

2 Replies
Opps, figured it out. Had relative and absolute mixed up...
best response confirmed by PrestonReed (New Contributor)


You need to use relative reference for rows, e.g. $AA3 instead of $AA$3