Creating a form that will add counts to the current database count

I am a complete excel novice so please bare with me.I have created spreadsheet (horribly i might add) that is tracking printer maintenance and toner change for my company's printer inventory. Once the data is input into one of the 2 columns it adjusts the 3 charts accordingly so that we can see problem printers. I want to create a form that will allow the techs to put in the ID of the printer and the number 1 in a box and it will add the data to the existing spreadsheet. This way i can put this on a shared drive and send the form shortcut to keep me from having to search the sheet and change the number. example is printer 12345 has 5 toner changes listed, they pull up the form and enter 12345 as the ID and 1 for just changing a toner and voila! printer 12345 now has 6 toner changes listed. I have attached what i have managed to throw together for my needs and like I said I am horrible with excel and this is still all a learning process. If I need to recreate the spreadsheet or what not I can I am just trying to simplify this as much as possible.

Hi

This sounds interesting so I will look at this for you.

I'll be back with a sample for you.

Ok

I've created something fun for you.

It is a lot more powerful than what you asked for. So............

Enjoy.

More powerful is a complete understatement!!! thank you so very much for this. I will have to dissect it a little to see how to do this! This will make my job alot easier!

It was my pleasure.

However I realised that I could add another bit of data to the Userform without too much effort that you might find useful.

I will leave it to you to work out what it does.

Enjoy.