Copy changing value to next cell

[Alexduplessis2001]

Here I have a excel "Lunchbox" Configurator. (I have attached a sample workbook and a screenshot)

To create a lunchbox you must choose 1 main, 1 side, 1 sweet. There are 3 availabe options for every main, side and sweet.

You can create a lunchbox configuration by selecting options from the dropdown list which will then display next to "Lunchbox combo".

I want to create a button that saves a configuration when the "save" button is pressed. This will place the luncbox combo next to day one. When a new configuration is created and the save button is pressed, it wil copy the text next to day 2. Creating a 3rd configuation a saving it will place it next to day 3 and so on.

I am only know starting to learn vba so any help or solutions will greatly be appreciated! Many thanks

Regards

[bebo021999]

OK. Try.

Right click on button, assign the code to.

[Alexduplessis2001]

Thank you )