Hi Alvin, I uploaded an example/explanation of what I'm trying to do. The file is called EXCEL_SPREADSHEET.xlsx in the file section. Not sure how to upload it to this message..
Thanks, Kristin On Jun 15, 9:35 pm, fongie <alvin.c.s.f...@gmail.com> wrote: > 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
