I have 2 workbooks, DTR Index and DTR Template.
When the DTR index is completed I need to open the DTR template and paste the values from one range to another, then save as a new file name.
I was partially there but it doesn't seem to want to work - I get a Run time error 91: Object variable...