I have an inventory table in excel 2013, every week we take inventory and input the actual amount in stock in column h which through a formula in column I displays the number that needs to be ordered to reach the minimum level of desired inventory for that item.
My goal is to have the numbers in column I copy over to sheet 2 along with column A (their part number) so that we create an order list. I've had problems doing this not only because I am a beginner at vba and therefore have very basic knowledge of how to write the code but also the fact that column I has a formula and I am asking for it to copy anything greater than zero, it's not recognizing it.
Any help would be great! thanks in advance.
Bookmarks