• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extracting data by Drop down menu

memonawais

New Member
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.
 

Attachments

  • Data.xls
    47 KB · Views: 14
Hi,

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?

Regards,
 
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
 
Back
Top