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

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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.
 
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Top