Hi Dave, Greetings from the US! This looks to be exactly what I need! Now, just to figure out how to implement it in my existing spreadsheet, which is a shared doc for numerous people to access...is it possible to start with your setup and change/add my real list data? I'll begin working with it to see.
Kristin On Jun 17, 4:03 pm, Dave Bonallack <davebonall...@hotmail.com> wrote: > Hi Kristan,Have a look at the attached. It's a stripped down and modified > version of a sheet I designed a while ago. Perhaps it will suit your > purpose.Note that there are more named ranges than are needed for this > modified sheet, but I couldn't be bothered sorting out which ones were still > needed, so I've left most of them in. There's a master list, which I hope > resembles your own master list, and a Main sheet with a product drop-down in > Col A, dependent drop-down in Col B, and a formula to fill in the adjacent > cell in Col C.Regards from Brasil - Dave > > > Date: Mon, 14 Jun 2010 11:32:27 -0700 > > Subject: $$Excel-Macros$$ Conditional Formatting and Pick Lists > > From: kristinmene...@gmail.com > > To: excel-macros@googlegroups.com > > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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 > > athttp://groups.google.com/group/excel-macros/subscribe > > _________________________________________________________________ > View photos of singles in your area! Looking for a hot > date?http://clk.atdmt.com/NMN/go/150855801/direct/01/ > > Kristan.xls > 154KViewDownload -- ---------------------------------------------------------------------------------- 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
