I would like to compare column A, B & C of sheet 2(testplan) with column B sheet 1(board).
For e.g. if the content in testplan sheet, cell 1 of column C is RV1, it should look for RV1 in the column B of board sheet. RV1 can be in any row in column of board sheet. It isnt necessary for the contents to be in the same row in both sheets.
So if RV1 is located in the above mentioned columns of both sheets then,
1) In column C of board sheet, we have to insert YES or NO. To determine whether to insert YES or NO, we have to look at the column A of testplan sheet. For e.g. if RV1 is located at cell C1 in testplan, Then we need to look at cell A1 of testplan.
If cell A1 is an empty cell, then we insert YES onto column C of board sheet.
If cell A1 is not empty, then we insert NO onto column C of board sheet.
In column D of board sheet, copy and paste the data from column B of testplan,
For e.g. if RV1 is located at C1 in testplan, Then we need to look at cell B1 of testplan and copy the data in it and paste on the column D of board sheet.
In Testplan Sheet, delete the entire row that contains RV1
If the content in one of the column C of testplan Sheet, is not in Board sheet of column B then do nothing
The column C of board sheet is not all blank cells and most of the cells are already filled with contents. So just replace those contents with the comparing.
The column D of board sheet is initially empty
This should be done for the entire column C of tesplan sheet
I have inserted a picture for better illustration
http://www.iimmgg.com/image/2076d4c0...80efee69d782a3
I have attached a sample workbook,
Attachment 4877
Inside the workbook it contains,
Board sheet and testplan Sheet are the sheets that need to be compared
Button sheet have a button where the codes should be included such that when the button is clicked it should compare the sheets
FinalBoard sheet is how the board sheet should look like comparing
FinalTestplan sheet is how the testplan sheet should look like comparing