code needed for stock inventory spdsheet. need to reset value of cell to zero upon saving

[mspeight2]

Hi guys,

I've been on excel all day and still can't find a solution to my design needs!! arrgh, can someone please help!

The issue is....

Cell B6 currently set to 0.

This column is named QTY INSTALLED

Cell E6 which has a fixed value of 10.

Column D is named STOCK LEFT

Column E is named STOCK KEPT (constant Value never changed)

I have the formula set up so it =E6-B6 This formula is entered in cell D6.


The vision for this sheet is for each individual job to be logged i.e STOCK LEFT to be constantly updated.

So if 2 unit are used (2 entered into cell B6 ) D6 will show 8 remaining units.

But When it comes to save the sheet. I need B6 to return to 0 but D6 to remain as it was.So when i log another job the stock left is adjusted say 3 more units used D6 will show 5.

The range is from B6-B100 D6-D100
Is there a way to do this. I apologise for my ignorance and possibly confusing explanation as im a novice when it comes to programming. But any help would be greatly appreciated!!

Thanks Mike

[dilipandey]

Hey Mike...

Welcome to the forum.

Please upload a sample file. Thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>

[protonLeah]

Please read and adhere to these simple rules!

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

[mspeight2]

hey guys please view my spreadsheet. any suggestions would be great!!

[dilipandey]

Hi mspeight2,

We all would be happy to help but first please follow the instruction given by Ben Van Johnson .... thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[mspeight2]

hey guys please view my spreadsheet. any suggestions would be great!!