rafi_07max
01-17-2011, 10:52 PM
I would like to compare column D and column F.
If the content in a cell in column F matches with a cell content in column D,
Then delete the cell in column F
Also delete the corresponding cell in column G
Take a look at the image below
http://www.iimmgg.com/image/734851830267808dcd2d38e37c7dd8c2
I have attached a sample workbook
Sheet 1 contains the initial set of data
Sheet 2 contains a button to insert the codes
Sheet 3 shows how the final output looks like
5252
If the content in a cell in column F matches with a cell content in column D,
Then delete the cell in column F
Also delete the corresponding cell in column G
Take a look at the image below
http://www.iimmgg.com/image/734851830267808dcd2d38e37c7dd8c2
I have attached a sample workbook
Sheet 1 contains the initial set of data
Sheet 2 contains a button to insert the codes
Sheet 3 shows how the final output looks like
5252