Reference Call
Nevermind. Thanks Cory! It worked!
"scott" wrote:
Hi,
I just have a small problem regarding reference call.
First Excel file has 2 sheets - 1st sheet has drop down Menu list that I
created based on formulas.
2nd sheet - has the field values populated as well as formulas.
When I move the 2nd sheet to another MS-Excel file, to reference a call back
to the 1st sheet, I don't see my drop down Menu field values now.
How do I reference the call (communicate) 2 different worksheets in 2
different files?
|