Hi
Here is the problem: I have created a workbook for the agency where I
work. It has a serious of sheets that have the various forms we have to use
to do our job and I have distributed this to the other people and they use
it to write their reports. But New York State has made some changes on a
few of their forms, so I have to change just them. These forms (sheets)
refer to other sheets in the workbook, but when I try pasting in the new
sheet I have created, the links to the other sheets in the workbook want to
refer back to the one I did the altering in -- the book I am working on.
How do I create a sheet that I can paste in that will refer to the other
named sheets in that book -- the tab names are the same in all workbooks
that employees have.
Ross