Auto fill

[Silo]

Hello Everyone

I have an employee sales report I am working with. It has employee names in column A, Items numbers in column B and Qty in column C.

The first employee name will start in cell A2, B2 will have the first item number sold, than B3 and so on.

If the first employee sold 7 different items there’ll be seven rows with item numbers (B2:B8) but the employee name will only reflect in A2 until the next employee. Example First employee A2, Second Employee A9 and so on.

Is there an auto fill feature (or VBA solution) to copy the employee’s name down then stop when it gets to the next name copy that name down and so?

I like to pivot this data

Thanks

 

[pleeseemailme]

Here is a simple loop that will work:

Sub fillin()

Dim cell As Range
Dim x As String


For Each cell In Range("A2:A20000")
    If cell.Value <> "" Then x = cell.Value
cell.Value = x
Next cell
End Sub

Adjust the range as needed.

 

[Silo]

Amazing... That worked prefectly... Thank you