How to extract the same data from different sheets

Discussion in 'Microsoft Excel Discussion' started by program_info@yahoo.com, Dec 1, 2005.

  1. Guest

    Hi,
    I need to extract the common and same data from four different sheets
    into one sheet. Could you please let me know how to do it?

    I can use VLOOKUP, but I need to generate one temperary sheet for any
    two sheets. And based on these temperary sheets, I need to use VLOOKUP
    to generate other temperary sheets. And then finally I could get the
    last result. Too complex.


    THanks.
    --Kening
     
    , Dec 1, 2005
    #1

    1. Advertisements

  2. Jerry W. Lewis Guest

    Can you say more about the structure of your data, how you are
    identifying "common and same data" and why you need all those temporary
    sheets to use VLOOKUP?

    Jerry

    wrote:

    > Hi,
    > I need to extract the common and same data from four different sheets
    > into one sheet. Could you please let me know how to do it?
    >
    > I can use VLOOKUP, but I need to generate one temperary sheet for any
    > two sheets. And based on these temperary sheets, I need to use VLOOKUP
    > to generate other temperary sheets. And then finally I could get the
    > last result. Too complex.
    >
    >
    > THanks.
    > --Kening
     
    Jerry W. Lewis, Dec 1, 2005
    #2

    1. Advertisements

  3. Piotr Guest

    Piotr, Dec 1, 2005
    #3

  4. Guest

    Thank you. Jerry and Peter.
    I've got the answer.
    I use IF and MATCH functions to do it. It is not very complex.

    I appreciate that you answered my email.


    --Kening
     
    , Dec 3, 2005
    #4

    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Karl Burrows

    Extract Unique Values, Then Extract Again to Remove Suffixes

    Karl Burrows, Jun 22, 2005, in forum: Microsoft Excel Discussion
    Replies:
    23
    Views:
    983
    Harlan Grove
    Jun 25, 2005

  2. Refreshing all data imports on different sheets from the same file at the same time

    , Aug 6, 2006, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    411
    Aug 8, 2006
  3. Suzette

    Protect sheets not allowing entering of data in multiple sheets

    Suzette, Sep 25, 2006, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    420
    Suzette
    Sep 25, 2006
  4. Matt G.

    Help w/ summarizing a mess of excel data from different sheets?

    Matt G., Oct 23, 2006, in forum: Microsoft Excel Discussion
    Replies:
    4
    Views:
    415
    Guest
    Oct 24, 2006

  5. Substituting linked sheets with new sheets by the same name - Excel 2003

    , Jan 10, 2007, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    480
    Jan 10, 2007
  6. Tony

    Need help comparing data from two different excel workbook sheets

    Tony, Sep 23, 2008, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    219
    Tony
    Sep 23, 2008
  7. Damil4real

    I have two drop list of the same data but in different sheets.

    Damil4real, Feb 3, 2009, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    290
    muddan madhu
    Feb 3, 2009
  8. Waleed Assuty

    Excel2007 | I want to create a pivotTable from a different data, and different sheets

    Waleed Assuty, Dec 22, 2014, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    295
    Waleed Assuty
    Dec 22, 2014
Loading...