Hi eveyone!
What I really need is a Macro that can compare three columns of data each on a different sheet. Excel 2010.
Here is step by step what it should do:
1) Take columnB on sheet1 and compare it with columnA of sheet2 and columnA of sheet3.
2) The result of this comparison should fill sheet4: all the duplicates should be cut off and the remaining items will be coloured red.
3) Comparison has to be non case sensitive and shouldnt take spaces into consideration.
4) The resulting rows on sheet4 should contain all the data present for the same items in sheet1 and structured in the same way.
Do you think it's possible to have such a thing?
Thank you in advance!
What I really need is a Macro that can compare three columns of data each on a different sheet. Excel 2010.
Here is step by step what it should do:
1) Take columnB on sheet1 and compare it with columnA of sheet2 and columnA of sheet3.
2) The result of this comparison should fill sheet4: all the duplicates should be cut off and the remaining items will be coloured red.
3) Comparison has to be non case sensitive and shouldnt take spaces into consideration.
4) The resulting rows on sheet4 should contain all the data present for the same items in sheet1 and structured in the same way.
Do you think it's possible to have such a thing?
Thank you in advance!