rafi_07max
11-10-2010, 08:33 AM
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 isn’t 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/2076d4c019bef896be80efee69d782a3
I have attached a sample workbook,
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
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 isn’t 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/2076d4c019bef896be80efee69d782a3
I have attached a sample workbook,
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