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'.
I've also attached the working file for reference! Do hope you guys can help me out. Thank you