DavG63
11-25-2015, 09:45 AM
Hi
I hope someone is able to help me with this. I've posted the same question on a couple of other forums but had no luck with a solution (I'm not apparently allowed to post links to these until I've posted more on the forum).
I have an Excel conversion of a bank statement which I would like to reorganise to remove unnecessary rows. The five columns are Date, Type, Description, Debit and Credit. Post-conversion some of the transactions run over several rows, ie.
Column A Column B Column C Column D Column E
25/11/2015 Transaction Name
Transaction Name
Transaction Name 10.00
I'm trying to write code that looks for the all the instances of a blank cell in the Date field (Column A), which have a value in either Debit (Column D) or Credit (Column E).
Once it finds an instance that matches, the code needs to move the values that are in either Column D or Column E to the nearest row in Column A above it that has a value (i.e. the transaction date) and where Columns D and E are blank (more for error checking than necessity).
Any help that anyone is willing to offer would be gratefully received.
Thanks in anticipation.
Dav
I hope someone is able to help me with this. I've posted the same question on a couple of other forums but had no luck with a solution (I'm not apparently allowed to post links to these until I've posted more on the forum).
I have an Excel conversion of a bank statement which I would like to reorganise to remove unnecessary rows. The five columns are Date, Type, Description, Debit and Credit. Post-conversion some of the transactions run over several rows, ie.
Column A Column B Column C Column D Column E
25/11/2015 Transaction Name
Transaction Name
Transaction Name 10.00
I'm trying to write code that looks for the all the instances of a blank cell in the Date field (Column A), which have a value in either Debit (Column D) or Credit (Column E).
Once it finds an instance that matches, the code needs to move the values that are in either Column D or Column E to the nearest row in Column A above it that has a value (i.e. the transaction date) and where Columns D and E are blank (more for error checking than necessity).
Any help that anyone is willing to offer would be gratefully received.
Thanks in anticipation.
Dav