Compare numbers and add to total

[bewise]

Hello,

I would very much appreciate it if someone could find a solution to this problem.
In my dummy workbook in sheet2 i want to compare numbers in cols C & F
if col C is larger than col F number then the player in the matching col gets 1 point added to col D on sheet3.
and the player whose number is lower gets minus one.It will be the same if col F is larger than col C.


see attached for dummy data.

Thanks.

[hectop]

This should do the trick. Run the macro Comp_Cols. If there is a tie, no one gets/loses the 1 point
Compare_Update.xlsm

[xladept]

Hi Bewise,

I haven't looked at hectop's solution - here's mine (since I went to the trouble, I decided to share):

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code under it

And, you should be ready to go

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

[bewise]

Hello
I thank you both kindly for your great codes,it is very interesting seeing two different codes doing the same job.

[xladept]

You're welcome