Hi
Can someone please help?
I would like to set up the following, can someone please tell me how I can do this?
I have a drop down list consisting of 5 values, Level 1, Level 2, Level 3, Level 4, and Level 5. When I choose Level 1 in the drop down box I want it to open a table in the worksheet I am in ... when I go into Level 2 I want it to open another but new table, and so forth with the other levels. Every time I select on the dropdown list and select a level its relevant table will appear. When I go back to level 1 I should be able to see what I had populated in that table.
I hope I have explained myself well.
Please help!
Can someone please help?
I would like to set up the following, can someone please tell me how I can do this?
I have a drop down list consisting of 5 values, Level 1, Level 2, Level 3, Level 4, and Level 5. When I choose Level 1 in the drop down box I want it to open a table in the worksheet I am in ... when I go into Level 2 I want it to open another but new table, and so forth with the other levels. Every time I select on the dropdown list and select a level its relevant table will appear. When I go back to level 1 I should be able to see what I had populated in that table.
I hope I have explained myself well.
Please help!