Help with doing a calculation >1000 times

[bmoore45]

I've built a calculator that will analyse different cards and assign a score (for a poker game).

I want to know how I can use the calculator for an entire list of flops.
Here's an example of the list of flops chart:

The real chart has >1000 flops, so manually inputting them into the input cells will be a nightmare. Basically I need each flop on this chart to be input into the pink cells in the calc chart, and the resulting score(below the pink cells) to be recorded in the blank cells on the list chart.

Do macros do this kind of thing automatically? I'm really stuck.

cheers,

Ben

 

[bmoore45]

bump; this must be harder than I thought. I gave it a few days and did some more research but I'm still stuck on this, sorry guys.

 

[Jerry Sullivan]

Hi Ben,

You could use the code below after defining names for these ranges.

From your first screen shot...
Flop_Current_Trial: 6 Columns by 1 Row
Score: 1 Cell

From your second screen shot...
Flop_Chart_Data: 7 Columns by ~1000 Rows beginning with your first row of data

Sub Run_Calcs()
    Dim i As Long
    Application.ScreenUpdating = False
    With Range("Flop_Chart_Data")
        For i = 1 To .Rows.Count
            .Offset(i - 1).Resize(1, 6).Copy
            Range("Flop_Current_Trial").Cells(1).PasteSpecial (xlPasteValues)
            .Cells(i, 7) = Range("Score")
        Next i
    End With
End Sub

bump; this must be harder than I thought. I gave it a few days and did some more research but I'm still stuck on this, sorry guys.

Don't forget to give feedback on your previous thread.. "Texas Holdem Math"

 

[bmoore45]

Thanks for the response! I'll give this a try tonight! Also I went back to that other thread, had forgotten about it sorry!

 

[bmoore45]

ok so all I need to do is define the ranges and use the names you have used and this should work? That is great stuff. I'm not sure how to do that but I think google is my friend for things as simple as defining a range. Thanks heaps!

 

[Jerry Sullivan]

ok so all I need to do is define the ranges and use the names you have used and this should work? That is great stuff. I'm not sure how to do that but I think google is my friend for things as simple as defining a range. Thanks heaps!

For this one, your best friend is probably the Excel Help since it will cut right to the instructions and save you some weeding out of related search hits.

Good luck at the Hold' em tables!