Need a single report sheet for all matches in my excel sheet

Posted on 2007-07-27
Last Modified: 2010-03-05

Need a single report sheet for all matches.

I have uploaded the sample excel sheet.Please give me a match.
A report which has Ram as header and when i click on the ram it should show all types of Rams.How many 512,1GB,5GB etc
Processor  the same thing how many id P2 2.8 etc.
In the header Rack no when i click should get how many asystems are there ion each rack.
When i click Used/Free i should get how many are free and how many are used.

Question by:bsharath
    LVL 11

    Author Comment

    Sorry uploaded the file in excel 2003 format
    LVL 13

    Expert Comment

    I think you will have to use command buttons to do this
    LVL 38

    Accepted Solution

    Hi Sharath,

    >  Need a single report sheet for all matches.

    Actually, a single PivotTable would be enough but here's your file showing a separate pivot table for each selection:


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    The problems with reply email signatures

    Do you wish that you could place an email signature under a reply? Well, unfortunately, you can't. That great Exchange/Office 365 signature you've created will just appear at the bottom of an email chain. What a pain! Is there really no way to solve this? Well, there might be...

    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
    Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now