I have a spreadsheet, which is attached. What I am looking to do is create a column next to "On-Hand" qty column so when a number is entered into the new column it will subract from the on-hand qty. I then want the ability to clear out the new column, but have the on-hand qty remain the new number. If this is possilbe to do, I would also like it to work with addition, as well. Any and all help is much appreciated.
Try this:
Insert the column next to your On Hand quantity column (this will create a blank column I).
Right-click on your Rack #1 sheet tab and choose View Code. Copy and paste the code shown below into the code window. Close the VBA editor.
On your Rack #1 sheet, type a positive number in any cell in column I to increase the On Hand quantity in column H for that item. To reduce the On Hand quantity, type a negative number in column I. If you delete the number from column I, nothing will happen to the values in column H.
Please Login or Register to view this content.
Thank you , That is exactly what I was looking for..
You're welcome. Glad I could help out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks