Macro to copy unique cells to another column

[Raju Radhakrishnan]

Hello, I have a macro which will copy unique cells from Column A & Column B to Column D. I want a macro which will copy cells which are available in Column a but not in Column b to column d and cells wihch are avaiable in column b but not in column a to column e. I am attaching my macro file. Kindly help me by amending the macro. Thanks a lot again

[MaczaQ]

This thread is almost the same as http://www.excelforum.com/excel-prog...html?p=2753852

below you will find my solution- only unique value from columns A / B excluding those which appear in column B / A

Please Login or Register  to view this content.

P.s. You have hidden column E in your example workbook ;-)

[Raju Radhakrishnan]

Thanks a lot. I need one more help in this excel. i.e. Column A consists of Data in xxx and Column B consists of Data in yyy. I want to rename those column's A,B,D & E so that my team get to know how to use this file. Thank you

[Raju Radhakrishnan]

I tried adding a heading in Cell A1,B1,D1 & E1 but while I run the macro the unique data also includes heading! Orelse can you amend the macro and start searching unique numbers from A2 & B2 and place the unique numbers from D2 & E2??? Kindly reply asap as am in office working on this thanks

[MaczaQ]

cosmetic change, here you are:

Please Login or Register  to view this content.

[Raju Radhakrishnan]

Thanks a lot ..... :D