Thanks Don but I want to be able to just move the worksheet as a tool from
one workbook to another. I will have a constant stream of new workbooks
coming my way into which I will need to plonk this 'reading and printing'
worksheet.

I just want those sheet1 references to stay 'sheet1!a1' and nothing else
without having to mess about - that is because there are 20 other people who
don't have much of a clue about Excel but face the same problem; it has to be
dead easy.


--
Regards

i4004


"i4004" wrote:

I am necessarily (someone else's system) working with 12 plus different
workbooks which are badly formatted so that they can't be easily printed. So
I have created a 'sheet2' which has references to pick out the data I want,
arranged as I want it to print it.

However, when I copy one of these 'sheet2s' to another workbook, all of the
references e.g. =a1 have the reference to the first workbook e.g. =
[workbook1]Sheet1!A2

I am more than happy with the 'sheet1' part but don't want the [workbook1]
part as, of course, this won't work when I put it in [workbook2]!

Help please!

--
Regards

i4004