maybe the step could be added to the existing macro.

For example at the moment it checks to see if the folder exists, If it does it moves to the next step and carries on the process untill it doesnt find a folder, as soon as no folder is found it then creates on, could there be a line of code that says when evere a folder is created or a folder is found copy filepath just created/found to cell F2 and then Exit Sub