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.

Solved: Excel: Automating select, copy, find, paste in order

Discussion in 'Business Applications' started by wazza330, Jan 30, 2013.

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

    wazza330 Thread Starter

    Joined:
    Jan 30, 2013
    Messages:
    2
    Hi everyone,

    There are two excel sheets I'm working on. The first is made up of 300 names of programs, one each row, and with 2 additional columns with version numbers and extra info. The second is a lot alike, but has about 100 rows and has 2 columns with different information from the first.

    example:

    Adobe premiere , 6.0.2, video-editing software

    Around 50 of these programs match by name (they are both in sheet 1 and 2), and i would like to import extra information about all matching programs from sheet 2 into sheet one, next to the existing information. That would mean that 50 or so rows have 2 additional columns and that about half of sheet 2 is left unmatched.

    By hand, this means copying the names from sheet 2, finding a match in sheet one, then copying the 2 columns from sheet 2 and pasting them in the corresponding location in sheet 1. I hope there might be a better way to do this. Does anyone know a way?

    Any help is appreciated.
     
  2. 20_2_Many

    20_2_Many

    Joined:
    Jun 29, 2012
    Messages:
    518
    Please use the Go Advanced button below to attach a copy of your workbook, and let us know what version of Excel you are using.
     
  3. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    Vlookup is a possible solution.
     
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/1087511

  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