Quickest way to fill in information

Morning all!

I'm trying to find a quicker way to fill in a sheet I use in my daily tasks in work. It's pretty much the same stuff all the time and is pretty mundane, I'd like to speed things up a bit so that I can spend time on other things. At the moment I use drop down lists to choose the info for each field in the green section, and then I copy/paste the info from 'Our Note'. (I've added images of this with the simple formula I use now)

I was wondering if it would be possible to use checkboxes instead of dropdown lists to fill the in the information? Or is there maybe another solution?

Any advice would be much appreciated,

Cheers,

Biskit

you could use a form in vba.

Is it always the same cells or how is the data organised?

Not really sure how check boxes would help here?

Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

I have just tried a couple of list boxes to see if you like them. Click on the listbox and the yellow lines will update

Cheers. I will presume you are ok to implement in your workbooks. If you need more info please ask.