Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Kicking Out Selective (Not all) Inactive Users | Excel Discussion (Misc queries) | |||
Update a list | Setting up and Configuration of Excel | |||
Calculating and Adding Hours, Minutes, and Seconds in a CALL LOG | Excel Worksheet Functions | |||
Relative reference to a cell on a previous sheet | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions |