"Ed from AZ" wrote:

As far as altering the source worksheet, why not copy the source rnage
into the backup file and THEN do all the manipulations? Or can you
simply close the source book without saving changes?

I'm not sure I understand, but I'd like to execute the code on the
sourcedata file, because this file is used over and over again.
Also, I don't want to have to open the backup file (the purpose is that my
colleagues can also execute this). Other problem is that the name of the
sourcefile is altered every 2 to 3 days.

And actually I can't really program, so I don't really know what every
function is used for.