You are welcome.Dave > Date: Fri, 18 Jun 2010 11:55:39 -0700 > Subject: Re: $$Excel-Macros$$ Conditional Formatting and Pick Lists > From: kristinmene...@gmail.com > To: excel-macros@googlegroups.com > > Hi Dave, > > I was able to use your solution and already have it implemented! > Everybody is really happy:-) Thank you so much for the help! > > I also wanted to thank Alvin and the others who have also provided > suggestions and solutions. What a great group! > > Thanks, again, > > 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 _________________________________________________________________ If It Exists, You'll Find it on SEEK. Australia's #1 job site http://clk.atdmt.com/NMN/go/157639755/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
