Copy & Paste Values of each worksheet into new workbook

[aserle]

Hi all,

I'm currently trying to put something together that copies the used range in each worksheet (except for the three first sheets) and pastes in a new workbook (ie. each worksheet copies across without formulas, and with the same worksheet name).

Here's what I have so far from reading forums and a bit of tweaking, but I seem to be on the wrong path.. any ideas?

Please Login or Register  to view this content.

Thankyou in advance!

[xladept]

Maybe:

Please Login or Register  to view this content.

[aserle]

Thanks for your prompt reply xladept - this looks like it would save each sheet to it's own worksheet? what i'm more aiming for is one that copies *all* worksheets to the one workbook..

[xladept]

I'll look again tomorrow.

[xladept]

Hi Aserle,

Maybe:

Please Login or Register  to view this content.