Hi all, pls see if you can help with the below:
I have sheet1 showing one column for dates and the next column showing account money movements like below example:
01Sep06 1000
04Sep06 (200)
12Sep06 500
How do I show on another sheet the daily a/c balance like below:
01Sep06 1000
02Sep06 1000
03Sep06 1000
04Sep06 800
.
.
.
12Sep06 1300
13Sep06 1300
.
.
.
30Sep06 1300
Have tried using pivot table but it will only sum and show account balance on those specific movement dates but not include all dates of a month.
Thanks!
I have sheet1 showing one column for dates and the next column showing account money movements like below example:
01Sep06 1000
04Sep06 (200)
12Sep06 500
How do I show on another sheet the daily a/c balance like below:
01Sep06 1000
02Sep06 1000
03Sep06 1000
04Sep06 800
.
.
.
12Sep06 1300
13Sep06 1300
.
.
.
30Sep06 1300
Have tried using pivot table but it will only sum and show account balance on those specific movement dates but not include all dates of a month.
Thanks!