VBA script that will allow me to copy the unit # in column C to the empty cells below unti

I would like to create a VBA script that will allow me to copy the unit # in column C to the empty cells below until it reaches the next unit #, then copies that unit # to the empty cells below it until it reaches the next unit# and so on.

I have attached a sample excel spreadsheet.

Really appreciate any help.

Thanks

Please Login or Register  to view this content.

Hi there,

Assuming the first Unit code to copy is in cell C6 (row 6).

Try the code below;

Please Login or Register  to view this content.

Hi FFarah,

this is another version

Please Login or Register  to view this content.

Try and let us know.

Bye

P.S.: if you want only value of cell, modify

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Or try this. No loop.

Please Login or Register  to view this content.

Thanks for the rep.

Let us know how you get on.

You're welcome.