Hi,

I have one page on a workbook which I wish to use on several other workbooks. This page has many formulas on. When copying the page to these other workbooks the formulas try to look back to the original workbook, for example:

Copying from: Workbook1
Copying to: Workbook2

=COUNTIF('[Woorkbook1.xls]Results'!B1:B500, "A")

I wish to copy the page over without it looking back to workbook1 all of the time. Both of the workbooks are set up the same with the same tabbed names.

Thanks