Previous Topic Next Topic

Comparing two excel sheet in vb 6

Closed
pranali - Apr 8, 2009 at 04:51 AM
setgold57 Posts 12 Registration date Friday March 20, 2009 Status Member Last seen June 15, 2009 - Apr 8, 2009 at 07:47 AM
Hello,
i am diploma student and plz plz any one can tell me how to compare two excel sheet in vb 6.0
that means there is 2 excel sheet contaning same data in both the sheet and both the sheet contain 24 thousand columns so i want to compare each feild of one each row with another sheet and if each feild of 1st sheet matches with the 2nd sheet then "yes" otherwise "no" should be display in "result" column which contain in sheet 1

1 response

Answer 1 / 1
setgold57 Posts 12 Registration date Friday March 20, 2009 Status Member Last seen June 15, 2009 3
Apr 8, 2009 at 07:47 AM
hi,
try this link to get help from Microsoft:
https://support.microsoft.com/en-us/office/how-to-compare-data-in-two-columns-to-find-duplicates-in-excel-fbeab47c-dd7a-4cf2-8aaf-50fc19d85dcc?ui=en-us&rs=en-us&ad=us
0

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses