Im new to VBA and I want to apply a code then I've written to store values in subsequent rows as I click a button.
I've created the following sub for only one particular row, but I would like to apply it further down the list (basically the whole of column F).
Now it is only working for the first row that is 'Pork'.
Sub RunMe() For Each Cell In Range("F2:XFD2") If Cell.Value = vbNullString Then Cell.Value = Range("F2") Exit Sub End If Next Cell End Sub
I've also attached the working file for reference! Do hope you guys can help me out. Thank you