Copying Sheets

Posted by Dwight on January 15, 2002 6:47 PM

Spreadsheet A has worksheet 1 and worksheet 2. Worksheet 2 has lots of formulas which reference cells in worksheet 1. I will need to copy worksheet 2 into many spreadsheets which will each have a worksheet 1 structured identically to the worksheet 1 in spreadsheet A. When I copy worksheet 2 into Spreadsheet B, I want a typical formula to read: "='worksheet1'!A1" and not "='[Spreadsheet A.xls]worksheet1'A1".

Any help?

Posted by Barrie Davidson on January 15, 2002 6:55 PM

Try Find & Replace where you are finding:

[Spreadsheet A.xls]

and replacing it with nothing (leave the replace box blank).

Regards,
Barrie
Barrie Davidson