Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 27th 07, 06:46 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 159
Default Formula to populate a drop down list based on the selection of ano

I am trying to create a worksheet to organize manufacturer and product
information. I have created a drop down list based on the manufacturers name
from lets say sheet 1 and I have the manufacturers products on lets say sheet
2, what I would like to be able to do on a whole nother worksheet (lets say
sheet 3) is to have a drop down list populated with the products of the
manufacter (lets say on sheet 3 cell a1) when I select a manufacturer from
(lets say sheet 3 b1).

Another question: How would I link the manufacturers name to there various
products.

  #2   Report Post  
Old September 27th 07, 06:54 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 449
Default Formula to populate a drop down list based on the selection of ano

Hi

For a non-vba solution, try
http://www.contextures.com/xlDataVal13.html

HTH. Best wishes Harald

"Mekinnik" wrote in message
...
I am trying to create a worksheet to organize manufacturer and product
information. I have created a drop down list based on the manufacturers
name
from lets say sheet 1 and I have the manufacturers products on lets say
sheet
2, what I would like to be able to do on a whole nother worksheet (lets
say
sheet 3) is to have a drop down list populated with the products of the
manufacter (lets say on sheet 3 cell a1) when I select a manufacturer from
(lets say sheet 3 b1).

Another question: How would I link the manufacturers name to there various
products.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
count based on selection from drop down list lovejunkie02 Excel Worksheet Functions 2 September 21st 07 10:04 PM
How to Auto-populate cell based on selection of a list item AK9955 Excel Discussion (Misc queries) 2 April 30th 07 10:04 AM
Move entire row to another worksheet based on drop list selection Coyote Excel Worksheet Functions 0 February 2nd 07 05:52 PM
Auto populate several cells based on a selection from drop down li Sheldon Excel Discussion (Misc queries) 3 January 13th 06 08:12 PM
need to populate several cells based on drop down menu selection TerriF Excel Discussion (Misc queries) 1 May 18th 05 10:27 PM


All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017