Hi All,

I have an excel file where in column G are listed transaction amounts and in Column H corresponding currency (USD, EUR and etc.).

G H
Row 1 5000 USD
Row 2 300 GBP
Row 3 150 USD
etc...

I want to write a VBA such that excel will delete rows when:

1. Transactions that do not exceed 10,000 USD
2. Transactions that do not exceed 8,000 EUR
3. Transactions that do not exceed 5,000 GBP

Many thanks for your help.


screenshot1.JPG