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
Bookmarks