VBA Code to Paste Values a Table Column Based on Values in Another Column

[demiwen12]

Hello - I need some help with a code that, through clicking on a button, will do the following:

If the cells in Table1 "Helper Column" = "Match", then:
1) Those cells in Table1 "Helper Column" will paste value into the same cells (i.e., remove the formulas and hard code them); and
2) The corresponding cells in Table1 "Sales" will also paste value in the same cells.

With the attached workbook example, this would mean F8:F10 and E8:E10 will be hard coded per #1 and #2 above, respectively.

Thank you in advance!!