Hi,

This is what I need to do:

I have a file with about 40 Worksheets containing customer statements,
every month I have to send them each seperate statement through email.
The orignal file is setup such that 1 main worksheet recieves data from
external source and populates statements in all the other worksheets.

Every month I move each worksheet to a new file and convert formulae to
values and send it to the customer. That 40 worksheets and hell a lot
of time.

Is there an easier way of moving worksheets then doing it one by one?

Cheers...
-Azm