Macro to Copy Data and Paste Values Based on cell criteria

Taislin,

Attached is a modified version of your posted workbook.
First, I had to get rid of all of the merged cells. They are a nightmare to work with, and it is quite easy to get the effect without actually using merged cells. You can select the "merge area" and right-click -> alignment -> for Horizontal select "Center Across Selection" -> OK

So, now that there are no longer merged cells to deal with, the code is pretty straightfoward. I assigned the below code to the Go "button" on the 'Menu' sheet:

Please Login or Register  to view this content.

[EDIT]:
Also, you had a typo on your market drop-down selection. It needed to be "FOOTBALL - MATCH ODDS" but you had "FOOTBALL -MATCH ODDS" (it was missing a space after the dash). Made that quick change and it worked just fine for that market.

Thank you for your adjustments. Its perfect. Didnt know that merged cells wore so hard to work with. Thank you.

Without all the other stuff, the Report page will look a bit empty, but here you go:

Please Login or Register  to view this content.