Merging two sets of data based on one value

**TommoBedhair** · 06-16-2012, 10:44 AM

Hi Guys,

Could do with some advice - as this task usually takes me a few hours whenever I have to do it - currently I'm copy and pasting in each individual code into the correct row.

I have one table with order numbers in the first column. I have another table with voucher numbers, which also have order numbers in the same column.

I need to be able to insert the vouchers into the other table - using the order number as the indenitfier so that the voucher with order number '11x' matches the order details with the correlating order number '11x' etc.

Any help would be massively appreciated.

Cheers in Advance,

Tom

**twiggywales** · 06-16-2012, 10:47 AM

Would be easier if you could upload a sample book

**TommoBedhair** · 06-18-2012, 10:52 AM

Attached.

Basically I need to get the vouchers with the correlating order id's from test2.xlsx to test1.xlsx

Anything you could do to speed things up would be greatly appreciated, I'm spending hours on this every day.

**twiggywales** · 06-18-2012, 01:56 PM

im not quite sure i get what your tring to do.

i see the order id and the voucher number but i cant see how they are referanced to the "matching order no"

can you try and explain a little clearer