var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I need to be able to enter data from a drop-down list to reduce errors. However, the drop-down data - lot numbers, sometimes 10 of them - will be dependent on the item number. How do I get Excel to look for data in a dynamic list?
So in column A you have item number, and column B is dependent on that? Here is a good explanation from Ozgrid Dependent List Explanation
old, slow, and confused
but at least I'm inconsistent!
(retired Excel 2003 user, 3/28/2008)
How to ask a question on forums
It's quite complicated and I don't know yet if I can simplify it for the users, but it sure looks good.
I have used this approach several times for my own work. Once you get the hang of it, it goes rather quickly.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors