How to 'hard copy' worksheets in new workbook?

[Ameube]

Hi,

I want to 'copy/hard-paste' up to 100 worksheets into a new workbook to get rid of all the formula's and external links that are in original workbook.

Can anyone tell me how to that without having to copy/paste each and every individual worksheet seperately?

Many thanks,
Marijn

 

[Andrew Poulsom]

Click the tab of the first worksheet then Shift+click the tab of the last worksheet. Press Ctrl+a, choose Edit|Copy then Edit|Paste Special, check Values and click OK. Finally exit Group mode by clicking the tab of any worksheet other than the active one.

 

[Ameube]

Thanks Andrew