Creating a button to remove a count on a stock list using only a part number as a REF

Hi All,



Just joined as i'm having difficulties with two kind of related issues.



1) My workbook is made up of roughly 25 worksheets relating to different manufactures of products we stock. I am trying to implement a bar code scanner into our stock taking procedure to minimise error and to speed the whole thing up (We are quite archaic over here).



I have uploaded and removed most of the information to make the workbook as small and uncomplicated as possible to you guys.



On the "Inventory Taking" sheet you will see an input box that will contain a serial number just scanned and a button either side to add or subtract from a data sheet stored on the worksheet "Source Page".



How can i get this to work so when i press a button excel searches the "Source Page" for the corresponding serial number then automatically either subtracts or adds 1 depending on the button pressed?



2)After Excel has automatically subtracted or added a stock item selected i would like the information in the cell showing serial number to be deleted and selected ready for more data input.



I appreciate this is probably simpler then i'm imagining but I've been at this nearly all week doing as much research without actually asking a question as i can. But i'm struggling to make google present me with answers to what i'm looking for.



I'm currently using Excel 2007.



Thanks for your time,



Ant.

I didn't realise a merged cell changed anything, thanks for that as it makes sense on another project i'm trying to complete.

I will try and input the code supplied via VBA when i get a chance and let you know how it turns out. Thank you JLGWIZZ



Mumps1; The workbook you have sent me sends me an error explaining the Macro's aren't available. Am i missing something or do they not transfer with the Workbooks?

Thank you both for your time. You will save me an awful lot of my own.

If you ever need advice on faulty computer hardware give me a message!

Kind Regards,
Ant.

Hi Mumps1;

These type of serial numbers occur because more then one of our suppliers provide an identical part with a different serial number. It's something that is being eradicated once i have this check in and out system sorted and being replaced by our own 13 digit serial numbers in the next week or so.

Hi Jack,

I like how robust this method is, but it's going to be implemented over a large touch screen device, because of this i wanted to press the minimal amount of buttons. I have attached the route i ended up going.

This is what i ended up with. The shortened version of course. The file normally opens with the S/N box already selected i just saved wrong... When used with the bar code scanner only one click is needed either the plus or minus and it's ready to take data again. It's great with the touchscreens.