Quick knowledge needed !! On a deadline !!

[abhi_rapid]

Hi Experts ,

I dont know excel, but want to learn it asap specially for the current requirement i have .

Requirement description (Excel 2007) : Code comaparison
1 workbook contains 3 sheets Comp , Jack , Jill named repectively ,
Jack has more code when compaired to Jill always :-

Step 1 - we manually import code to Sheet Jack from a txt file on the desktop , similarly we do it on sheet Jill

Step 2 - While exporting we split the code into 4 columns , and ranges from Column A to Column D on both Jack and Jill

and no of rows depends on code length , they dont exceed 50000

​

Step 3 - We copy the four Columns contents till the no of rows with data from Jack and paste into sheet"Comp" from 2nd row onwards in colums A B C D , similarly from Jill in to F G H I of sheet"Comp"

Now all work is done on Sheet"Comp"

Step 4 - Change the font to Courier new of sheet"Comp" and font size to 11 , zoom the sheet to 74% , expand the colums C and H to Show complete content .

Step 5 - Put formula =IF(AND(B2=G2,C2=H2),"Matched","NON Matched") in Column H and
Put formula =IF(AND(C2=H2),"Content Matched","NON Matched") in Column K

Step 6 - Do Step 5 until Column H has NON Matched .

Step 7 - If Column H and Column K both have NON Matched for a particular row, we check if the content from the Column H comes lower down in Column C , if yes - we insert blank lines in Columns F to G till we bring it parallel to same code in Column C and Column H. We colour the extra lines above Yellow in Column A to D , if no - we colour both sides A to D and F to G in RED and move to the next line .

Step 8 - If Column H is NON Matched and Column K is Content Matched , then we colour both sides A to D and F to G in Green and mention in Column L "Commented"

This we do till the end of the code manually

AFTER step 2 onwards, Can I do all this in VBA automatically , logically i am ok with but syntax i am struggling with here, any kind of suggestion , command suggestions , links from you guys would help . I need to get this done by tomorrow and its appearing an uphill task for me currently .


Regards
Kumar Abhishek

 

[Asala42]

Did you just ask us to do your homework for you?

I'll give you a few hints that should get you started:
1) You can use the Record Macro/Stop Recording feature to get the basic syntax on some of these steps.
2) Conditional formatting is another good feature for the color portions

 

[abhi_rapid]

Did you just ask us to do your homework for you?

I'll give you a few hints that should get you started:
1) You can use the Record Macro/Stop Recording feature to get the basic syntax on some of these steps.
2) Conditional formatting is another good feature for the color portions

Not really ... just wanted advise or suggestions as i mentioned in my post ...
.

Best way to ask i thought would be to describe the problem

Tnx for ur suggestions ..will try them out