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
Bookmarks