If

[jothecat]

Hi,

I am new to vba programming. I am looking to solve this with a macro:

An excel sheet has this kind of data:

John Murphy---London---2kg butter---Invoice no. 2111
John Murphy--London--500g cheese--Invoice no. 2111
John Murphy--London---2kg tea---Invoice no. 2111
John Murphy---London---2kg coffee ---Invoice no. 2456
Jack Doe---New York ---3kg butter--- Invoice no. 2677

I want to remove the Name and City of the cells following IF the Invoice number is the same. It should lool like (sorry not sure how to show excel columns here):

John Murphy---London---2kg butter---Invoice no. 2111
----500g cheese--Invoice no. 2111
-----2kg tea---Invoice no. 2111
John Murphy---London---2kg coffee ---Invoice no. 2456
Jack Doe---New York ---3kg butter--- Invoice no. 2677

My knowledge of the IF statement, running down the columns until there are no more rows etc. is limited.

Thanks.

[mikerickson]

Please Login or Register  to view this content.

[jothecat]

That was fantastic. Looking at the code, and following the logic was very educational. Thanks.