Inventory Supply Sheet

I can think of several ways to do this using a macro. The simplest would be one that activates on close, pasting the numbers from column F into column C, and clearing column D.
Unfortunately, this would require that the users have macros enabled, which is often a pain when you want to widely distribute something.
Perhaps somebody else has another idea?

That works for what I want but the numbers are off.. If I put 1 in the number taken section it takes two out instead of 1

That works but now the number taken colum doesnt disappear and the Quantity number stays the same.

Thanks for your help I really appreciate it

Try this code in a macro, either bound to a button or run otherwise:

Please Login or Register  to view this content.

It's very hard-coded, ie you'll need to manually change the references to 19 if you expand the list.

Does that help?

@ Jeffrey I changed the false to true and it still does the same thing. the number taken section does not clear after you enter in a number. the correct number is subtracting correctly

@Rosilisk would I enter this in the same spot (the view code section) or would I enter it some where else. I put it in the view code section and it didnt seem to do anything. Am I missing something?

I am sorry my mistake @jeff it does work properly I tried it again but is there a way to make the number under Quantity update after you enter the number you took?

I have bound it to a button in this case. I pasted it in 'module 1' within the workbook, and when creating the button under 'developer' -> objects I selected the 'refresh' macro.

See the attached spreadsheet.

Thank you guys I appreciate it these files both work just how I was thinking.
@jeffreybrown thank you the file works perfectly now
@rosilisk the button Idea I really like thanks agian

I will show these both to my boss see what one he wants to use but both will work. Thanks again for your help guys