The problem that I have created is I have a worksheet of orders, dates, and quantities and so one. I also have a pivot table that contains orders and quantities that need to be expedited. I use getpivotdata to bring in the expedited date and quantity; of course where ever it finds the order number it marks it with the date and quantity. So the problem I have is that I want it to mark the orders that have the relevant quantities, if I need 50 and I have an order with 3 lines with qtys of 20,40, 25, I only want it to mark lines for 20 and 40, I don’t need the line for 25 yet. So is there a way to do this with an UDF after my getpivotdata marks everything or during the getpivotdata. So I hope someone has an idea because I think I am spent, trying to think of things.
Thanks,