Deleting Duplicate Columns
 

Hi Guys,
I am looking for Macro which can delete duplicate colums. Will th
Macro work if the Column has a different heading than the Data in th
Row itself. For Example If I want to delete Column G (Sales Data) an
Column J (Total Invoice) for which Both the Data in the fields ar
AUD.

Please guide,
Thanks in Advance
Kuma

--
Kumar_2
-----------------------------------------------------------------------
Kumar_26's Profile: http://www.excelforum.com/member.php...fo&userid=3259
View this thread: http://www.excelforum.com/showthread.php?threadid=52400

Deleting Duplicate Columns
 

You can go to data, auto filter, custom and find matching columns:

--
davesexce
-----------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...fo&userid=3170
View this thread: http://www.excelforum.com/showthread.php?threadid=52400