Looking for a possible answer to this question.
I have a workbook with several tabs and one of the tabs is the Data tab. I want to copy the Data tab into another workbook that needs this data but i get a #Ref error within the formula, and Vlook-up does not work. Is their a way to resolve this without copying and pasting all the data from one workbook into another?
Thanks, Roy
I have a workbook with several tabs and one of the tabs is the Data tab. I want to copy the Data tab into another workbook that needs this data but i get a #Ref error within the formula, and Vlook-up does not work. Is their a way to resolve this without copying and pasting all the data from one workbook into another?
Thanks, Roy