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.
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.