VBA To Create Folder Based on Cell Value and Save File as Same Cell Value...HELP!

Hi everyone, I'm very new to VBA and I have some code from a former employee but I need help fixing.
I'm trying to do the following with VBA Code.

1. Data will be entered into a row in a file that has been opened (Problem Tracking.xls)
2. A macro button will be clicked
3. The Macro will ask what row to copy data and the person will input the row number
4. Copy the selected columns in the row
5. open a file called "Supplier SQD Master.xls" and input the data into the cells.
6. Create A folder in Path F:\Copy Test\2015 SQD\Issued using Cell G4 and C5
7. Save the file as G4 and C5 to the created folder but remain open
8. Create a hyperlink in the Problem tracking.xls in Column "R" and the row selected from the input box.

I have it working up to item 6 but I can't seem to figure out how to save the file into the created folder and create a hyperlink into Problem Tracking.

Please Login or Register  to view this content.

thank you Humdingaling,

#8.
Once the SQD master is saved to the folder. I want to switch back to the open Problem Tracking.xls and create a hyperlink in column R of the selected row that the SQD master was saved to.