Copy Paste Cell (formula) "X" number of times to column that matches value

[stephaniedoiron]

Hello, I'm trying write a code that will do the following:

1. Search in row 3 for the column that matches the value in cell B2.
2. Copy cell A2 (which contains a formula), and paste it in the column that was found in step 1 starting in row 5 and going down "X" number of times where "X" is the value of cell C1.
3. Copy and paste special as values the data that was just pasted in step 2 (in order to remove the formulas).

Please let me know if you need more info. Many thanks!
- Stephanie