Hi,
One way to accomplish this is to copy the entire Sheet 2 of Book A and paste it entirely in Sheet 2 of Book B. Then while in Sheet 2 of Book B use the Find and Replace command to replace all instance of Book A in all the formulas and replace them by 'blank' (or nothing). This way you will remove all references of Book A from the formulas leaving the references pointing only to Sheet 1 which is the sheet in the current book.
Hope this helps. Let me know if you have any questions.
BS Degree in Engineering.
25 years experience in computer programming and troubleshooting. Planning & Construction Management
Sorry, I do not quite understand what you're saying. Is this a new requirement or something? as it is does not seem to be the same thing that you asked in the original question? And what does 'w/b 2-75' mean?
I did not say copy the entire workbook, What I said was copy the entire sheet, which is apparently what you are trying to accomplish. In fact if you read my first reply carefully you will find that it does address this issue you are describing.
Anyway don't you agree that without seeing the actual file there isn't much more that we can do.