LinkBack URL
About LinkBacks
mgwillimk 
I don't see where your available stock is stored on your posted spreadsheet; it doesn't look like what you originally described. There are no total quantities, and none of the parts in sheet2 have an associated quantity.
I don't see where your available stock is stored on your posted spreadsheet; it doesn't look like what you originally described. There are no total quantities, and none of the parts in sheet2 have an associated quantity.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Apologies, i saved the file incorrectly. I have rectified this and am now uploading the most recent version. Annoyingly it is not uploading properly at the moment and will try again in a while
Here is the file. It is a basic version of what i am doing but should suffice to play with
See the workbook I've posted. I changed your Qty column on sheet2 to hold the original qty, and then created a new column to hold the remaining qty. Will this work for your purposes?
If you'd prefer to change the Qty column instead, you'll probably want to use a macro. You'll need something to trigger the macro to run. How would data be entered into sheet 3?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks