Thanks folks,

Two different but workable approaches to the same problem.

Many thanks,

BlueTig

"T Kirtley" wrote:

You could just copy the sheets you want to distribute for data collection and
when you get updated worksheets back copy/paste the data (not the
spreadsheets themselves), back into the appropriate sheets of the original
workbook. That should not break any formulas as long as the structure of the
data does not change.

Alternately, you could put the 'data collection' sheets into a separate
workbook. To do this just drag the sheets out of the original workbook into a
new workbook, (the workbook window must not be maximized to do this) and save
it with a name of say, Data.xls. Your 'reporting module' formulas should now
have external links to the sheets in the Data.xls workbook, so now you should
save the 'reporting module' workbook.

Now you can distribute copies of the Data.xls file to collect new data, and
when you get updated sheets back just save them back over the original
Data.xls. (Do this while the 'reporting' workbook is closed). Then, when you
open the 'reporting module' it will refer to the new data.

Hope that does it for you,

TK

"BlueTig" wrote:

I have an Excel 2003 workbook that I wish to split in to two sections (3
sheets and 2 sheets).
The two sheets will remain as a 'reporting module' whilst the others will be
copied many times and re-used for data gather.
I need to be able to paste the data sheets back into the worbook with the
reporting module and the formulaes to remain correct.
Is there a way of doing this? As soon as I cut the data sheets out of the
original book, the formulae change to #REF and then don't work when the new
data is pasted back in.
I know that the incoming sheets need to keep their original name but is
there a simple method I can use?

Thanks