kevinh2320
Board Regular
- Joined
- May 13, 2016
- Messages
- 61
I need code that will loop through my work sheet and if there is only a single entry for an Account# then leave that record. But, if there is multiply rows with that account number delete all rows with that account number except the most recently entered row based on the TransactionDate. Example worksheet below - the highlighted rows represent the records to keep. Thx for any help.