Hi Kristin, Have you got an email I can send a file sample to? I cant seem to attached a file in here.
Alvin On Jun 15, 2:32 am, Kristin <kristinmene...@gmail.com> wrote: > 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
