1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Data from one excel into another by using predefined rows

Discussion in 'Business Applications' started by abhinandan, Jul 25, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. abhinandan

    abhinandan Thread Starter

    Joined:
    Jul 25, 2012
    Messages:
    9
    Hello,

    I am in need of a Excel tool (may be VBA/Fucntion..) :rolleyes: where in I get the data from a spread sheet into another based on the 3 cells of a row.
    EX: Excel 1 is having 3 columns defined (A, B, C) & each row in these columns will have predefined numbers as shown below:


    Using these I need to get the data from Excel 2 (where we have the columsn A, B, C) for columns D, E....


    Compare row 1: X1,Y1, Z1 in excel 1 & excel 2 to get cells D1, E1& F1 data to be filled from Excel 2.
     

    Attached Files:

  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,891
    First Name:
    Wayne
    do you have excel 2 sheet ? can you upload ?
    - you should be able to use match and index or vlookup to get what you want
     
  3. abhinandan

    abhinandan Thread Starter

    Joined:
    Jul 25, 2012
    Messages:
    9
    hi,

    Find the Excel 2 sheet for Reference.
     

    Attached Files:

  4. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,891
    First Name:
    Wayne
    i think a vlookup would work OK but need a little more info

    do you know what columns the ABC data will be in ?
    and also you want ABandC to meet the requirements - so we would use a concatenate and compare - which may mean adding an extra column - still thinking about that

    so Vlookup
    would look at sheet 1 ABC - then look for that combination in sheet2 and copy across columns DEF
    so had to add the extra column in my example

    see attached - i have added into the same worksheet - but should be able to lookup on a different work book

    see my next reply for using a different workbook - which has to also be open (we can also do it closed on a file path)
     

    Attached Files:

  5. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,891
    First Name:
    Wayne
    with separate spreadsheets
     

    Attached Files:

  6. abhinandan

    abhinandan Thread Starter

    Joined:
    Jul 25, 2012
    Messages:
    9
    Thanks a lot for the solution.
    What I see is that, in both the cases we need some manual tuning required before we get the results. I can have a template & include the helper column & I manually enter data's from excel1 & excel 2
    I would also be interested to know any VBA script which supports to generate data based on the columns A, B, C & reduce manual tuning & also A,B,C data's may be in any columns in excel 2.
    Thanks again for the solution.
     
  7. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    :D:D:D
     

    Attached Files:

  8. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,891
    First Name:
    Wayne
    ok my solution will not work
    to help a macro guru , the columns abc will they be together ie three consecutive columns or can they be any columns - and so you are just trying to find the three entries anywhere in the row
     
  9. abhinandan

    abhinandan Thread Starter

    Joined:
    Jul 25, 2012
    Messages:
    9
    That is exactly what I am looking for....
    Sorry on missing this initially.
     
  10. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,891
    First Name:
    Wayne
     
  11. abhinandan

    abhinandan Thread Starter

    Joined:
    Jul 25, 2012
    Messages:
    9
    The a,b,c columns will be three consecutive columns which may be anywhere within the sheet.
    I need data from other columns based on these columns respective to a row.
     
  12. abhinandan

    abhinandan Thread Starter

    Joined:
    Jul 25, 2012
    Messages:
    9
     
  13. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1062616

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice