Quote Originally Posted by Norie View Post
Why does it need to get done in a specific order?

If you do it the way I suggest you'll end up with the exact same result.
Because we dont want to have to do anything with the workbook we will be creating. unless you mean write it so it happens all from the one click in the 1st workbook? If so could you show tell me how to do it please?

Again im new to vba and macros etc. so im sorry if im coming across as quite slow, please be patient :D