Hi Kristin it seems you want to link 3 columns, if you select Particular Prod Name then base on that, column 2nd & 3rd reflect values, i herewith attach sheet, where 3 columns are link with drop down, hope its as per your requirement,
for better understanding of your query send a sample sheet to this group. On Tue, Jun 15, 2010 at 12:02 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 > -- ---------------------------------------------------------------------------------- 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
Sample dropdown.xls
Description: MS-Excel spreadsheet
