Aug 05, 2009 09:28 AM|anil.shah007|LINK
Hi For your First question u need to create a sheet and then put the requried value in few column then go to desired cell where u want to create a drop down with those data. keep rememebr that that cell should contain a list which will be appear on click
on that respected cell.....
This is the logic.........
If u face any prob then plz let me know so i can elobrate u in details.