Excel: filling of cells using vba with simple criteria

Hi, I have an sheet that contains 1000 records. In the sheet I would like to fill the empty cell using criteria. For example: A4 contains value B and A10 contains Value C. So I would like to put H from A4 to A10, similarly A34 contains value B and A50 contains C so I would like to fill between cells with H. The total records are more than 1000, Any suggestion?

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of September 17, 2016.

For more resources for Microsoft Excel