Mazbuka
New Member
- Joined
- Sep 23, 2018
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
I have an excel journal template that I want completed from a cashbook type source...I'll show a simple example:
Say this is my cashbook
<colgroup><col span="4"><col><col span="3"><col></colgroup><tbody>
</tbody>
<colgroup><col span="4"><col><col span="3"><col></colgroup><tbody>
</tbody>I need relevant cells copied into the cash journal below
If D2 above = "cash", copy A2, B2, C2 & D2 above into A2, C2, D2 & E2 below respectively.
However if D2 above = "check" then Look at D3 above, if that's = "cash" copy from row 3 above into row 2 below, if it's ="check" then disregard and look at D4 & so on.
End result will look like this.
<colgroup><col span="12"><col></colgroup><tbody>
</tbody>
Say this is my cashbook
A | B | C | D | |||||
1 | DATE | DETAIL | AMOUNT | CASH/CHECK | ||||
2 | 17-10-19 | John | 1000 | CASH | ||||
3 | 17-10-19 | Joan | 1200 | CASH | ||||
4 | 17-10-19 | Fred | 1500 | CHECK | ||||
5 | 17-10-19 | Pat | 800 | CASH | ||||
6 | 17-10-19 | Mary | 900 | CHECK | ||||
7 | 17-10-19 | Steve | 750 | CASH |
<colgroup><col span="4"><col><col span="3"><col></colgroup><tbody>
</tbody>
<colgroup><col span="4"><col><col span="3"><col></colgroup><tbody>
</tbody>
If D2 above = "cash", copy A2, B2, C2 & D2 above into A2, C2, D2 & E2 below respectively.
However if D2 above = "check" then Look at D3 above, if that's = "cash" copy from row 3 above into row 2 below, if it's ="check" then disregard and look at D4 & so on.
End result will look like this.
<colgroup><col><col><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody> </tbody> |
<colgroup><col span="12"><col></colgroup><tbody>
</tbody>