hi, this is the 2nd part of my auto banking project
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
sheet 3
<tbody>
</tbody>
i wuld like to have vba populate sheet 1 column c with the data from sheet 2 column c
i would like to cycle through this for date +1 - 180 days
so on the 2nd of each month it would insert 105 into column c. also there is another table that has weekly payments. so every wednesday it would have 30. so it needs to calculate sheet 1 column c with sheet 2 column c and insert it.
if worksheets(sheet1.columnA)=(current Date + 1) = 4th then
worksheets(sheet1.columnc).value = worksheets(sheet2.columnc) + worksheets(sheet1.columnc)
obviously that isnt how to write it otherwise i wouldnt be here.
thank you
Sheet 1
| Column A (Day) | Column B (Date) | Column C (Amount) |
| Monday | 2/9/19 | 0 |
| Tuesday | 3/9/19 | 0 |
| Wednesday | 4/9/19 | 0 |
| Thursday | 5/9/19 | 0 |
| Friday | 6/9/19 | 0 |
<tbody>
</tbody>
Sheet 2
| Column A (Date of each month) | Column B (bank) | Column C (amount |
| 1 | mine | 100 |
| 2 | mine | 105 |
| 3 | ||
| 4 | Mine | 101 |
| 5 |
<tbody>
</tbody>
sheet 3
| Column A (day of week) | Column B (Bank) | Column C (amount) |
| Monday | mine | 100 |
| Tuesday | ||
| Wednesday | Mine | 30 |
| Thursday |
<tbody>
</tbody>
i wuld like to have vba populate sheet 1 column c with the data from sheet 2 column c
i would like to cycle through this for date +1 - 180 days
so on the 2nd of each month it would insert 105 into column c. also there is another table that has weekly payments. so every wednesday it would have 30. so it needs to calculate sheet 1 column c with sheet 2 column c and insert it.
if worksheets(sheet1.columnA)=(current Date + 1) = 4th then
worksheets(sheet1.columnc).value = worksheets(sheet2.columnc) + worksheets(sheet1.columnc)
obviously that isnt how to write it otherwise i wouldnt be here.
thank you
