+ Reply to Thread
Results 1 to 2 of 2

transfer data between workbooks

  1. #1
    Forum Contributor
    Join Date
    06-30-2008
    Location
    PSL, FL
    Posts
    271

    transfer data between workbooks

    Guys I am serious need of help here.

    I got two xls sheets.

    Worksheet A
    I6:91 has SIM CARD IMEI numbers

    Worksheet B
    P3:133 has Sim CARD IMEI numbers also



    This is what I need

    I need Worksheet A to match Sim Card IMEI numbers from Worksheet B then copied the neighboring cells Q and R to column J and K respectively on worksheet A.

    Does this make sense.

    For example Worksheet A only has the IMEI numbers but need its matching description and cell number. This information is in a much larger xls report (Worksheet B). So I want to just grab the data that matches and bring it to a much cleaner smaller Worksheet A.


    Is this possible.

    Matt

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: transfer data between workbooks

    Assuming worksheet A and B are inside the same workbook

    In J and K
    = VLOOKUP(I6,Worksheet2!$P$3:$R:$133,2,FALSE)
    and
    = VLOOKUP(I6,Worksheet2!$P$3:$R:$133,3,FALSE)
    dragged down.
    Is that what you are looking for?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1