selection from the same list at various places(cells)

martha555

New Member
Joined
Jun 28, 2005
Messages
41
:) hi,
I want to create an excel file, the format of which is as shown belo:

# Product Grade

The product and grade will be selected from a given list. My problem is that when I type the numbers under #, viz., 1, 2, 3 and so on, the corresponding product and grade lists should be displayed in the respective cell, where I should be able to choose my product/grade value, which will then be displayed in that cell. Then numbers under # may vary from 1 to 20. Finally, I would like to print the sheet. How do I go about it. Please help.
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,118,909
Messages
5,574,986
Members
412,630
Latest member
Eireangel
Top