I have a set of test sheets for the job I do that I wish to modify. I have another set that I can not use but it has a reference table that I do want to use. When I have tried to incorperate it into my workbook I have found the following problems:

1) The original reference table scrolls but when it is copied it does not.
2) Sometimes it forms a link with the original work book which I do not want.
3)Though I have copied the original formulas to refer to the reference table it does not seem to work in the new one.

Can anyone help?