filling of cells using vba with simple criteria

[rehanemis]

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?

 

[rehanemis]

Excellent...!!!!!!!!!!!!!!

 

[rehanemis]

Much Thanks

 

[Rick Rothstein]

Much Thanks

You are quite welcome... glad we were able to help.