Visual basic Code needed to compare the excel

April 7, 2011 at 10:55:17
Specs: Windows Vista
Please write the visual basic code to compare the below 2 excel sheets and write result in 3rd excel sheets with non matching values as RED color background.

all 3 columns of first excel sheet will be compared with the last three columns of second sheet.
Unmatched will be colored with the RED background i.e. cell with 3005,8001,1300 and 4002 should be in RED backgroud

Worksheet1:

Name TotalMark Marks
ABC 850 400
DFG 700 300
EFD 800 300
RPG 800 350
SNT1 800 400

Worksheet2:
ID LEVEL Name TotalMark Marks
1 100 ABC 850 400
2 100 DFG 700 300
3 100 DFG 700 300
4 100 DFG 700 3005
5 100 DFG 700 300
6 100 SNT1 800 400
7 100 SNT1 8001 400
8 100 SNT1 800 400
9 100 DFG 700 1300
10 100 DFG 700 300
11 100 DFG 700 300
12 100 RPG 850 400
13 100 RPG 850 400
14 100 RPG 850 4002
15 100 SNT1 800 400
16 110 SNT1 800 400
17 150 SNT1 800 400


See More: Visual basic Code needed to compare the excel

Report •


#1
April 7, 2011 at 11:48:33
The purpose of such an assignment is to make you think about the problem and devise a solution. That is what programming is all about. If you are unable to do this you need to talk to your teacher or tutor. The worst thing that could happen is for someone to do this assignment for you. You would learn nothing that way.

This forum can only help you with specific questions.


Report •

#2
April 7, 2011 at 12:14:24
Could u plz help out if possible.......

Report •

#3
April 7, 2011 at 12:54:38
To get help with programming assignments you must show the code you have and ask a specific question.

Report •

Related Solutions


Ask Question