Copying values from another spreadsheet

**omar.b** · 07-09-2007, 09:36 AM

Any help for an Excel noob?

I need to automatically copy certain fields from 1 spreadsheet into another. But the fields obviously all need to copy into specific rows.

For example

Sheet 1

Unique ID Hours Remaining Hours Cost
1 20 17 2100
72 12 1 1489
64 12 9 100
23 90 67 45000

Sheet 2

Unique ID Name Code Hours Remaining Hours Cost
72 Bob 1089
1 Ron 4456
23 Amy 1112

So the unique identifiers are not in the same order in the two spreadsheets.
I need to automatically update all rows in spreadsheet 2 with the corresponding values in spreadsheet 1.

I believe I need to record a Macro, but am not sure how to go about it .

Any help will be greatly appreciated.

Kind regards

**SamuelT** · 07-09-2007, 10:02 AM

You should be able to use VLOOKUP to achieve this. If you don't know about this function, check this link:

http://www.ozgrid.com/Excel/excel-vlookup-formula.htm

HTH,

SamuelT

**omar.b** · 07-09-2007, 10:21 AM

That link is certainly useful, however it doesn't go into as much detail as I need.

Ideally I would like to create some kind of macro so that I do not need to continuosly enter a new formula each time a new row is created. Also the link doesnot show you how to write the formula for copying in fields from another spreadsheet and it only searches the first column in the table whereas I need to match column 3 in spreadsheet 1 to column 2 in spreadsheet 2.

Many thanks