Inserting weekly information with a userform

[JamesT1]

Good Morning

I'm working on a sreadsheet for inserting and collating information for a fleet of vehicles.

I have userforms for inserting various pieces of information when the vehicle is new or leaving the fleet.

I would like to use a userform for inserting weekly information. I know how to insert the basic information in columns but I'm stumped for working in rows and with inserting information at different times.

Could someone please help me with the code, I have attached a sheet showing the kind of layout I am thinking off. The vehicle registration will be picked up from another spreadsheet

Thanks for your help

[royUK]

This is one way

[JamesT1]

royUK

Once again thank you for your help,,,,,still learning an this will point me in the right direction for figuring out what I want,,,,, one last question on the spreadsheet.

Rather than insert a list of weekendings into the sheet, what would I need to do for the user to insert the weekending and the sheet automatically put it into the next empty cell

[royUK]

You would need a textbox to input the date into. Replace the combobox that holds the dates with a textbox then delete all the old code, replace it with this

Please Login or Register  to view this content.

[JamesT1]

Thanks RoyUK

this will help me big time,,, much appreciated