I have been given a horrible task that I hope somebody could help me with. I have 2 worksheets with very simular data in,
Sheet 1
A B C
partnumber opnumber descrip
0040123 10 machine
0040123 20 cut
0040123 30 inspect
0040123 40 t/ments
Sheet2
A B C
partnumber opnumber descrip
0040123 10 goodsin
0040123 20 dip
0040123 30 final
Each sheet has maybe 5000 differant part numbers and varying amounts of opnumbers. What I have been asked to do is merge the cells from sheet2 into sheet1 where partnumber=partnumber and sheet1 descrip=t/ments. I would be grateful if anybody could help me
Sheet 1
A B C
partnumber opnumber descrip
0040123 10 machine
0040123 20 cut
0040123 30 inspect
0040123 40 t/ments
Sheet2
A B C
partnumber opnumber descrip
0040123 10 goodsin
0040123 20 dip
0040123 30 final
Each sheet has maybe 5000 differant part numbers and varying amounts of opnumbers. What I have been asked to do is merge the cells from sheet2 into sheet1 where partnumber=partnumber and sheet1 descrip=t/ments. I would be grateful if anybody could help me