Pull down list to trigger other fields

**prateeque** · 09-18-2009, 02:32 AM

I'm trying to create an excel sheet to cost some activities
My fields would be
Day Location TypeofAccomodation No.ofRooms RoomRate CampRent Guide
1 Kochi Hotel 5 500 NA NA
2 Munnar Camp NA NA 1500 350

I want to have a pull down menu for Type of Accommodation where i can choose either Hotel or Camp and then depending on which choice the only relevant fields can get filled up. Is there a way of doing this.. or even better if i choose "Hotel" is there any way that there is a pop up or a link to another page where i can fill in all the details that are relevant for that day.

Thanks

**zbor** · 09-18-2009, 02:35 AM

In first row (Day Location TypeofAccomodation No.ofRooms RoomRate CampRent Guide) ad Filter (Data->Filter) then you can filter by any column (including Hotel, camp).

is that help?