Userform for battery logging

[CameronGates]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Battery[/TD]
[TD]lift [/TD]
[TD]hours in[/TD]
[TD]hours out[/TD]
[TD]blank[/TD]
[TD]lift [/TD]
[TD]hours in [/TD]
[TD]hours out[/TD]
[TD]blank [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RR01
[/TD]
[TD]RR23[/TD]
[TD][/TD]
[TD]1545[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RR02[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RR03[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RR04[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RR05[/TD]
[TD]RR23[/TD]
[TD]1545[/TD]
[TD]1550[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RR06[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RR07[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RR08[/TD]
[TD]RR23[/TD]
[TD]1550[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RR09[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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.