Macros for MLB odds table

[IdabaMalouki]

Please Login or Register  to view this content.

I use the above macros to sort MLB Odds that I copy and paste into Excel. The website changed formats (again)! Can someone tweak that code so that data sorts into the same columns in the spreadsheet posted below. Thanks in advance.

MLB_ODDS_CAESERSFIX.xlsm

[6StringJazzer]

Appears to be a follow-up to, but not an outright duplicate of, a previous thread with the same title.

[IdabaMalouki]

Yes, the web site changed the formatting of the data I copy and paste into Excel. I'm hoping someone can tweak the macros again to adjust for the data format change.

[hungt]

What MLB Odds sort are you talking about? Do you want to derive the results in columns C:J from the data in column A? If so, I don't understand, for example, where you have the data in G2, H2, because they are not in A1:A10.

I assume that you want to derive the results in C:J from the data in column A

1. Delete sub x() from module Sheet1 (ODDS)
2. Add Module1 (Insert menu --> Module)
3. Code in Module1

Please Login or Register  to view this content.

[IdabaMalouki]

Thank you. Works like a charm.