Reference Call
 

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?

Reference Call
 

Nevermind. Thanks Cory! It worked!

"scott" wrote:

Hi,

I got partly there. The problem is that I've got my first sheet in MS-Excel
with a drop-down Menu. The second sheet, after I moved it to the second
MS-Excel file, is populated with their field choice lists, and formulas.

When I go back to my first sheet, i won't be able to see the drop-down menu
because it's not reading the second sheet I moved.

What should I do?

"Cory" wrote:

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?

Reference Call
 

Hi,

I got partly there. The problem is that I've got my first sheet in MS-Excel
with a drop-down Menu. The second sheet, after I moved it to the second
MS-Excel file, is populated with their field choice lists, and formulas.

When I go back to my first sheet, i won't be able to see the drop-down menu
because it's not reading the second sheet I moved.

What should I do?

"Cory" wrote:

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?