Matching two sets of data

[cjh1984]

Hi all,

I have two spreadsheets and both spreadsheets contain a number o
projects. One contains the name and info about them and the othe
contains the costs for them. Each project is identified with a code
But in one spreadsheet the code is, for example, 000012.R. And i
another is 000012. I need to match up those codes within eac
spreadsheet and insert the correct cost against the respective projec
in the project info spreadsheet.

Can anybody tell me how to go about this or how to get started on it.
If you need more info just say!

Any help will greatly be appreciated!

Thank Yo

 

[Frank Kabel]

Hi
use VLOOKUP for this. e.g.
=VLOOKUP(A1 & ".R",'other_sheet'!$A$1:$B$100,2,0)

 

[cjh1984]

Thanks,

Also, is there anyway using a macro or vba that i can select, fo
example A1:F212, and copy it into a new workbook

 

[Frank Kabel]

Hi
just record a macro while doing this manually