Moving multipule sheets into their own workbooks

I have a workbook with many spreadsheets in it for customer pricing, each
customer has a sheet of their own. I need to email each particular sheet as
an attachment to each customer, is there a quick easy way to have each sheet
copied and pasted into its own workbook in one or few easy steps instead of
doing each one separate?

I know I've done this before and can't remember what I did, LOL.

Any help would be appreciated.

Thanks!

Kathy in WI

Hi Kathy

Try something like this

http://www.rondebruin.nl/mail/folder1/mail5.htm

Or

http://www.rondebruin.nl/mail/folder2/mail5.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"[email protected]" <[email protected]> wrote in message news:%[email protected]...
>I have a workbook with many spreadsheets in it for customer pricing, each customer has a sheet of their own. I need to email each
>particular sheet as an attachment to each customer, is there a quick easy way to have each sheet copied and pasted into its own
>workbook in one or few easy steps instead of doing each one separate?
>
> I know I've done this before and can't remember what I did, LOL.
>
> Any help would be appreciated.
>
> Thanks!
>
> Kathy in WI
>