Thread: Deleting Rows where some Cells have same Content
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JamesT[_2_] JamesT[_2_] is offline
external usenet poster
  
Posts: 1
Default Deleting Rows where some Cells have same Content
Hello

I am after a Macro that will delete rows where information is the same in
defined columns.... I have data that is similar to the following, but extends
across several comumns, but I only want to conern the macro with the first 3
colums for instance:

Name Book Language

James Flowers French
James Flowers French
James Flowers German

Name Book Language

James Flowers French
James Flowers German

I want it to leave me with, can anyone help with a VB Macro?

thanks
Reply With QuoteReply With Quote