Updating data lists via outside table source

Hi

How about a workbook_open event macro that builds the list from a central point every time the workbook is opened.

Don't know what you define as simple, so I don't know if it would be a viable option for you or not.


rylo

Thanks rylo, I did a little test with that. I am not proficient with Excel Macros, nor VBA.

That workbook_open event macro will work, but I also can't figure out how to point the cells in the worksheet to the tables on another worksheet. I am using Excel 2007 and its HELP menu.

Any advice?

Thanks.

Hi

A couple of thoughts.

1) Have the macro put in links to the table, and just keep bringing the formulas down until you bring back a blank entry. Then convert the formulas to values, and make it a defined name. Have the drop down refer to the defined name.

2) Do the same sort of thing and bring the values to an area that doesn't matter, then create the dropdown list from those details. Record a data validation list to get the code.

3) Another way is to do a query (data, import external data....) and have it bring back the values to a particular area. Again either do a defined name, or recreate the validation list.


See how you go with that. I'm not sure from your post if you are using a data validation dropdown, or a combo box from one of the forms toolbars. If you need some more help, can you clarify.

rylo

rylo