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