Macro look up between two columns deleting non-partial matches


Aim: Macro to reduce a list of trades with clients, to a list of only those with clients defined as "Priority" from a pre determined list.

Functions: Macro should be able to:

1. From the "Data" trades, identify trades where client name includes those in the "Priority Client" tab

N.B: it needs to recognise if the Counterparty column "contains" the names from the Priority List, not the exact that name

2. The list of "Priority Clients" will be dynamic and will increase / decrease regularly

3. The end result should be a finite list in a new tab showing only those lines where the client in data contains details from "Priority Clients".

4. Preferably have a bar which shows how long the macro still has left to run if it isn't going to be quick.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!