Macro to Create and link a Note Sheet

I would like to have a button that when clicked copies "Note Template" to a new workbook, and then saves that workbook at a user specified path. After the workbook is saved, I would like the macro to insert a hyperlink to that file in the highlighted cell. Would be even better if I could pull values from specific cells in the original workbook to use as the file name when saved.

Filename desired is always in column E, same row as the highlighted cell desired for use.

I have a bit of programming background, but I have never used VBA or any language like it, so this is a bit tough for me to figure out.

here's what I have so far:

Please Login or Register  to view this content.