Help Needed For Excel

Discussion in 'Software Q&A' started by saigalp, Jul 11, 2006.

Thread Status:
Not open for further replies.
  1. saigalp

    saigalp New Member

    Joined:
    Sep 2, 2005
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Delhi
    I have a file in Excel containing around 22000 items. Out of which I want to select and export around 3000 items to another file. Please guide me as to what is the easiest and fastest method to do this.
    Thanks in advance.
     
  2. tuxfan

    tuxfan New Member

    Joined:
    Feb 4, 2004
    Messages:
    2,653
    Likes Received:
    9
    Trophy Points:
    0
    Location:
    Mumbai
    How is the sheet formatted? What does it contain? Give more details.
     
  3. sms_solver

    sms_solver New Member

    Joined:
    Jan 2, 2004
    Messages:
    420
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    somewhere
    If 22000 items is in a column then u can make use of Advanced Filter option of Excel
     
  4. OP
    OP
    saigalp

    saigalp New Member

    Joined:
    Sep 2, 2005
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Delhi
    The sheet has 3 rows, A- contains Part no., B- contains Description, C- contains
    The Price. I want to select the required part nos. and export to another file.
    Awaiting response,
     
  5. rakeshishere

    rakeshishere HELP AND SUPPORT

    Joined:
    Jun 9, 2006
    Messages:
    1,604
    Likes Received:
    30
    Trophy Points:
    0
    Copy the items whichever u want and open another file and use PASTE SPECIAL FEATURE
     
  6. Ramakrishnan

    Ramakrishnan The Researcher

    Joined:
    Mar 7, 2006
    Messages:
    1,154
    Likes Received:
    10
    Trophy Points:
    38
    Location:
    Mumbai
    use the autofilter feature. You can use it to filter in any combination and permutation and get the data you want easily. data>filter>Autofilter
     
Thread Status:
Not open for further replies.

Share This Page