Sunday, 8 September 2013

Excel find similar cells from another sheet and copy and paste those rows under first sheet cell

Excel find similar cells from another sheet and copy and paste those rows
under first sheet cell

I have two excel sheets with a lot of rows.. This is what I need.
**A B C E F G**
abc test1 123 dfg 369 258
adf test2 345 mmm 896 147
mmm test3 256 mmm 852 951
**Sheet 1 Sheet 2**
What I need
**A B C F G**
abc test1 123
adf test2 345
mmm test3 256
mmm 896 147
mmm 852 951
Hope I don't have to explain in word.. can someone tell me how to do this???

No comments:

Post a Comment