I am having trouble copying a sheet from one workbook to the other. The original sheet is filled with countifs that reference another tab in the original workbook. This same tab is identical in the second workbook. I have tried moving the tab and I have also tried copying the information and pasting the tab but nothing seems to work. The formulas still reference the path of the original workbook, ie: [Excel-Report.xlsm]Sheet1! Is there a way to merge the two workbooks so this tab is in the new one? Is it just a matter of using paste special (something I have also experimented with)?
Thanks for your help...
Bookmarks