I am new to Excel formulas. I have 3 list in 3 different columns in Sheet2 as below.
<colgroup><col style="width:48pt" width="64" span="3"> </colgroup><tbody>
</tbody>
<tbody> </tbody> | |||||||||||||||||||||||||||||||||||
In sheet1, i want to create a dropdown list of the Listnames e.g. List1, List2, List3. Depending on the Listname selected, i should be able to populate the rows of that list in the rows below the list name. I don't know how to do it and Macros are also not enabled here. Please any help will be greatly appreciated. | |||||||||||||||||||||||||||||||||||
<colgroup><col style="width:48pt" width="64" span="3"> </colgroup><tbody>
</tbody>