adding to a combo list

  • Thread starter Thread starter Zygoid
  • Start date Start date
Z

Zygoid

I am trying to create a drop down list in cell D5 in wb1. i want the
list created from a column in wb2. i have read in data validation that
both workbooks have to be open. is there a another way without having
both open?

reason i ask: i have 2 workbooks, one for entering data to create
estimates and workorders, another workbook for storing data such as
customers list, material list, work area list, etc.

i do not want users opening and seeing the list workbook.

i have been able, with alot of help from this forum, to create forms
to add to list wb from data inserted into cells on wb1.
but now i would like to create a drop down list in cell D5 (customer
name) of wb1 from the column A in wb2 which has all of my customers
names.
 
Hi
one idea for a workaound. Create a new sheet in your active workbook
and 'copy' the data with a cell reference from your list-workboot. Use
this sheet as source for data validation and hide it.
AFAIK there is no way to use data validation with a closed workbook so
I'd choose this kind of workaround

Frank
 
Thanks for your reply.

i thought of that. but was hoping there was a vba code that could do
it. without creating a hidden worksheet.

eventually, these workbooks will be placed in a pocket PC and i am
trying to keep the wb1 as small as possible. right now the size is okay
to add, but i plan on doing more and have to watch the size of the
file.
 
Is your list static?

Maybe you could just have a range of cells that have links to your other values?

='C:\my documents\excel\test\[Book5.xls]Sheet1'!A1
(kind of thing)

Then use that range.

But remember to not update links when you open the workbook--are links possible
in Pocket Excel?

(I've never seen it.)
 
Back
Top