Hi Everyone,

I need to make some amendments each month to a sales spreadsheet for a particular client. I've tried to set up a macro for automating this, and can get most of the way there, but there's one thing I can't do.

I need to look for all orders where there are multiple items packaged as one. At least one of these items must have a value below £75, and at least one must have a value of £75 or greater (orders made up of multiple items but every item is >= £75 or ever item is < £75 don't need to be amended).

Column C (starting from C20) is the Order ID. All items within the same order will have the same Order ID.

Column Y (starting from Y20) tells me if they're packaged together, so this will read True for the orders I want to pull out.

Column AC (starting from AC20) holds the values of each individual item.

So essentially, what I'm looking for is a way to highlight (or copy to a new sheet) all items where they share the same order ID, have a combined packaging state of True, and have a mix of values above and below the £75 cut off point.

Any ideas?

Cheers,

Ben