rincewind_wizzard
Registered User.
- Local time
- Today, 01:58
- Joined
- Feb 7, 2018
- Messages
- 23
Hi all,
I have an payroll general ledger file which has employee numbers and credits and debits. Due to system issues, there have been a lot (thousands) of extra rows written to the file which Finance do not want to load in to their systems. I'm trying to think of a way of deleting the unwanted rows but I'm failing miserably. I'm on leave from Tuesday so need to crack this today/tomorrow. I have attached the file. Yellow entries are the ones to keep, the others to delete. Basically, any entry for an employee that has the same values in both the credit and the debit column need to be deleted. This may be something to be achieved using VB so sorry if it's posted in the wrong place.
I've stared at this for hours now and can't see the way forward so any help much appreciated.
Cheers
Paul
I have an payroll general ledger file which has employee numbers and credits and debits. Due to system issues, there have been a lot (thousands) of extra rows written to the file which Finance do not want to load in to their systems. I'm trying to think of a way of deleting the unwanted rows but I'm failing miserably. I'm on leave from Tuesday so need to crack this today/tomorrow. I have attached the file. Yellow entries are the ones to keep, the others to delete. Basically, any entry for an employee that has the same values in both the credit and the debit column need to be deleted. This may be something to be achieved using VB so sorry if it's posted in the wrong place.
I've stared at this for hours now and can't see the way forward so any help much appreciated.
Cheers
Paul