Hi,
I have to present data figures of according to category wise. I have data of various categories. What I want that on single sheet there should be Drop menu and present the required data on same sheet as appended in Excel Sample sheet with sample data.
Can you explain more about your requirement:
1. Your Main Sheet has 6 headers, Do you want them in Dropdown?
2. If various options are selected than what should come in the display area?
Somendra Misra,
As stated, 6 headers data should appear in the area highlighted in yellow when clicked on respective header. Like When one clicks on BHs with Top balances, data from Top Balances sheet should appear in yellow box. The purpose is to limit the movement within Sheets. This will ease the reader to review the data on same sheet. Thanks