I am trying to create 3 columns for an ongoing monthly master spreadsheet. The data includes: Product Name (highest level of info), Product Item # (essentially, a part #), and Product Description. Currently the list is 193 records long.
I'd like for the first column (Product Name) to be a pick list consisting of 7 product names (I've got this done). The second column to be a pick list based on which product name was picked in the first column and only show that subset of the master list pertaining to that product line. And, the third column to auto-fill the product description for column two's product id. Is this possible? I've been researching pick lists and conditional formatting, but can't seem to find a situation/example to where both are utilized within the same cell/column. I guess I need to know if this is possible and if not, I'll just go with pick lists for each column and hope for the best in accurate data. If this is the only option, is there a limit to how long the pick list is? Lastly, I am not a developer and am not familiar with VBA or other scripting languages, etc. Thank you in advance for your help! Kristin -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
