The code below works with renaming workbooks, however it also moves them as well.
Is there a way to modify the code to make a copy of the workbook instead of moving it?
Thanks much in advance!
Dim OldName1, NewName1
'Work books based on cell values below