Hi Kristan,I got most of the ideas for the dependent drop-downs from this site:http://www.contextures.com/xlDataVal13.htmlThis is an excellent site, with lots of ideas, all clearly explained. It's worth working through the examples they show, in a clean sheet before trying to implement the method/s into existing workbook/s.Regards from Brasil (but only here visiting family - I'm usually in Perth, Australia)Dave.
> Date: Fri, 18 Jun 2010 08:52:44 -0700 > Subject: Re: $$Excel-Macros$$ Conditional Formatting and Pick Lists > From: kristinmene...@gmail.com > To: excel-macros@googlegroups.com > > 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 _________________________________________________________________ Browse profiles for FREE! Meet local singles online. http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- ---------------------------------------------------------------------------------- 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
