in the below sample i need a macro that will save the sheet as a copy every time it updates. I need it to save as the info in cell D1, and to a specific file. I currently have it saving everytime it updates but not as a copy, and this is causing me issues.
Batch choochoo.xls
Bookmarks