Hey team, i have two workbooks and both have different names. In both workbooks their is a tab named "DATA". I want to be able to delete the "Data" on the destination workbook and copy the other into this workbook. I tried moving/copy the data tab from one workbook into the other and i got an REf# error.
This is the formula on the workbook before i copy the data tab:
=IF(ISERROR((IF(ISBLANK(VLOOKUP('Cover pg 1'!I42, DATA!1:65536,3,FALSE)),"",(VLOOKUP('Cover pg 1'!I42, DATA!1:65536,3,FALSE))))),"",(IF(ISBLANK(VLOOKUP('Cover pg 1'!I42, DATA!1:65536,3,FALSE)),"",(VLOOKUP('Cover pg 1'!I42, DATA!1:65536,3,FALSE)))))
This is the formula after i copied the data tab:
=IF(ISERROR((IF(ISBLANK(VLOOKUP('Cover pg 1'!I42, #REF!1:65536,3,FALSE)),"",(VLOOKUP('Cover pg 1'!I42, #REF!1:65536,3,FALSE))))),"",(IF(ISBLANK(VLOOKUP('Cover pg 1'!I42, #REF!1:65536,3,FALSE)),"",(VLOOKUP('Cover pg 1'!I42, #REF!1:65536,3,FALSE)))))
Is there a way to move/copy the data tab without causing all types of errors (including macros).
Thanks, Roy
This is the formula on the workbook before i copy the data tab:
=IF(ISERROR((IF(ISBLANK(VLOOKUP('Cover pg 1'!I42, DATA!1:65536,3,FALSE)),"",(VLOOKUP('Cover pg 1'!I42, DATA!1:65536,3,FALSE))))),"",(IF(ISBLANK(VLOOKUP('Cover pg 1'!I42, DATA!1:65536,3,FALSE)),"",(VLOOKUP('Cover pg 1'!I42, DATA!1:65536,3,FALSE)))))
This is the formula after i copied the data tab:
=IF(ISERROR((IF(ISBLANK(VLOOKUP('Cover pg 1'!I42, #REF!1:65536,3,FALSE)),"",(VLOOKUP('Cover pg 1'!I42, #REF!1:65536,3,FALSE))))),"",(IF(ISBLANK(VLOOKUP('Cover pg 1'!I42, #REF!1:65536,3,FALSE)),"",(VLOOKUP('Cover pg 1'!I42, #REF!1:65536,3,FALSE)))))
Is there a way to move/copy the data tab without causing all types of errors (including macros).
Thanks, Roy