Jasmine1508
New Member
Hi All.
Attached is the excel workbook that has two sheets. First sheet is the data. Here if i select a particular state, i need to display its contents only which are in its adjacent columns. for example if i select Andhra pradesh, i need the data result as per second sheet.
Options needed:
1. Freeze Panes of Headers
2. If i need to take a print, auto selection of entire Andhra pradesh (in spite of selecting it manually) in print preview should come.
3. Filters of state/using dialog box display, the state can be selected despite of manual typing.
Pls assist.
Thanks a lot for all.
Jasmine
Attached is the excel workbook that has two sheets. First sheet is the data. Here if i select a particular state, i need to display its contents only which are in its adjacent columns. for example if i select Andhra pradesh, i need the data result as per second sheet.
Options needed:
1. Freeze Panes of Headers
2. If i need to take a print, auto selection of entire Andhra pradesh (in spite of selecting it manually) in print preview should come.
3. Filters of state/using dialog box display, the state can be selected despite of manual typing.
Pls assist.
Thanks a lot for all.
Jasmine