Macro or excelfunctions
 

Hey,

I have a problem in Excel and I think I have to write a Macro for that. But
I have no experience in VBA.

Maybe someone can help me out..

I have two sheets (A and B). I have too match these sheets on the base of
some columns. If the columns match then I want to cut the whole line out of
sheet B and paste it after the matched column in sheet A.

Example
Sheet A Sheet B

1 AA X1 4 BLA VLE K5
2 BB D2 6 GGG JJJ L9
3 CC V5 2 HJH HJH D2
4 FF K5

SheetA.Colum1 = SheetB.Column1 and SheetA.column3 = sheetB.column4

Results
Sheet A SheetB
1 AA X1 6 GGG JJJ L9
2 BB D2 2 HJH HJH D2
3 CC V5
4 FF K5 4 BLA VLE K5


Thanks a lot
Nic