Userform for battery logging

[CameronGates]

Battery	lift	hours in	hours out	blank	lift	hours in	hours out	blank
RR01	RR23		1545
RR02
RR03
RR04
RR05	RR23	1545	1550
RR06
RR07
RR08	RR23	1550
RR09

<tbody>
</tbody>

So I've got a spreadsheet formatted like this and I'd like to make a userform for it but am quite illiterate when it comes to Visual Basic. Basically this is a battery run time chart that is used to track how long the batteries are last between changes. When a lift comes in you populate the lift field with the lift number on the corresponding battery row and then populate the hours out with the hours from the lift. Then you populate the Lift number in the lift field with the corresponding battery row for the battery you are now inserting into the lift and then in the hours in field you populate it with the same hours you had in the hours out with the old depleted battery. We have three different people inputting data into this spreadsheet that are quite illiterate with spreadsheet data entry so a userform would be a great way to remove much of the human error out of data entry in this spreadsheet. Any help would be much appreciated!!!!

 

[CameronGates]

That's strange I'm only allowed one private message, lol. So I had one in my sent items and my box was full. Anyways I have since deleted it. Sorry about that, that's the first time I've encountered that on a forum. I probably need to contact an admin on raising the pm limit.