I think that you are into a big job proceeding as you suggest. You wish
to retain the links to other workbooks, right ?

Why don't you just copy the existing workbook under another name ?

If you wish, all you need to do then is record a macro which deletes
rows/columns you don't want and perhaps does Edit/Copy/PasteSpecial
Values to replace formulas with values.

To have this work on all worksheets in the book you can make a loop
like :-

'------------------------------------------------------
Sub reformat_sheets()
For Each ws In Worksheets
ws.Activate
Macro1 ' or whatever your code sub is called
Next
End Sub
'----------------------------------------------


---
Message posted from http://www.ExcelForum.com/