Reference Call
 

Make sure you have both WB's open, right click on the Tab you want to move to
the second sheet and select move or copy. Select the book you would like to
move it to. The formulas from the tab you move should still be reference to
the correct location.
--
CCO


"scott" wrote:

Hi,

I have an entire MS-Excel file created. I have two sheets in there. The
first sheet is a display of a drop down menu. The second sheet has formulas
inputted in their cells. I would like to move the second sheet to another
MS-Excel file and reference a call to the first sheet of the 1st MS-Excel
file. How do I do that?