Hi all,
I am trying to accomplish a small task and I cannot find a suitable answer from the web search sources I have so far found.
My scenario is that I have an excel form with a field called "Names" that is a drop-down list. This drop-down list is populated from data on another worksheet (called "Names Lookup") within the same workbook. This is working successfully. The population takes place using VBA code.
I want to move the "Names Lookup" worksheet to a new workbook and populate the "Names" field from this other worksheet in the new workbook.
Is it possible to achieve this by directly accessing the data in the "Names Lookup" worksheet in the other workbook and populate the "Names" field accordingly?
Many thanks for any responses.
I am trying to accomplish a small task and I cannot find a suitable answer from the web search sources I have so far found.
My scenario is that I have an excel form with a field called "Names" that is a drop-down list. This drop-down list is populated from data on another worksheet (called "Names Lookup") within the same workbook. This is working successfully. The population takes place using VBA code.
I want to move the "Names Lookup" worksheet to a new workbook and populate the "Names" field from this other worksheet in the new workbook.
Is it possible to achieve this by directly accessing the data in the "Names Lookup" worksheet in the other workbook and populate the "Names" field accordingly?
Many thanks for any responses.