OK, so I got another brain-teaser, for me, at least.
I have a worksheet named "Order Form"; column A is order quantity and column B is part number, and the rest of the columns are for misc. stuff like UPC, MOQ, weights, measurements, msrp, sell price that customers use for information.
I want to strip out the data for order qty and item number and put it onto a new worksheet called... lets say its called "EDI".
so, on this new worksheet I have a formula that reads = B1 and another that reads = C1 which basically pulls info to it. There are 9000 items, so then once a order is entered on the order form, I go to the EDI tab and filter for every order qty greater than zero. submit form.
NOW TO MY QUESTION:
is there a way to reverse filter a pre-filtered list so that once an order qty has been entered, the corresponding line "infilters itself" or do you guys have any other ideas that may make this "order entry" process as step-less as possible?