Help Needed want to impress the Boss
Hi all
After a back injury my boss as taken me of fitting and put me in charge of the stores.
I am slowly sorting the stores out which was like a bomb site but to make my life easier I want to put the entire stock on a pc.
I am having a little problem with incoming stock when entering the figures into the spreadsheet
What I am trying to do is on delivery’s (Sheet1) is enter the amount in Colum D and the when I put a "y" in Colum E and press Enter or Down Arrow the amount being added to Stock (Sheet2) Colum G and the Delivery amount (Sheet1) Colum D being deleted without it being deleted from the Stock Sheet2) Colum G
Attached is what I have done so far
Hope this makes sense and someone could solve this for me and help me gain some brownie points.
Thanks in advanced for any help offered
|