« GEOMETRY: How do you find the area of a rhombus when your given the perimeter and one diagonal?
Algebra Word Problem: Mixture »

How do I filter excel data from one Master worksheet into a different worksheet?

I have a Master list of conferences for different clients. I would like this data to filter into a different worksheet (same excel file) for each client seperately. I tried Advanced filter and had no luck. Each client has their own tab/worksheet. I dont want to have to copy and paste - I would like excel to grab the lines of data where the client is mentioned and filter it onto their seperate sheet.
any help woudl be appreciated!!

type "=(sheetname)!(cell)

=Sheet1!B6

You will then be able to click and drag bottom right corner of cell to "copy formula" and it will extend like.. =Sheet1!B7… =Sheet1!B8… etc

Good luck

This entry was posted on Friday, July 3rd, 2009 at 8:55 am and is filed under worksheet. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “How do I filter excel data from one Master worksheet into a different worksheet?”

  1. jimbobjrbob Says:
    July 3rd, 2009 at 2:07 pm

    type "=(sheetname)!(cell)

    =Sheet1!B6

    You will then be able to click and drag bottom right corner of cell to "copy formula" and it will extend like.. =Sheet1!B7… =Sheet1!B8… etc

    Good luck
    References :

Leave a Reply