mbdigital
10-16-2014, 05:41 AM
Hello to you all.
I am just for a week or two busy with simple VBA codes.
Here is a question which goes far above my knowledge :
Attached is a sheet where all my payments are placed (sheet 1).
My wish is to have all details from sheet 1 placed into sheet 2 but in the following way :
(SHEET 1 - Row 6)
Every month I pay "Alimentatie D" so
Sheet 2 must have
a row with details (cell B4) January , (cell C4) Alimentatie D , (cell D4) amount , (cell C5) afschr.dat
a row with details (cell B4) February , (cell C4) Alimentatie D , (cell D4) amount , (cell C5) afschr.dat
a row with details (cell B4) March , (cell C4) Alimentatie D , (cell D4) amount , (cell C5) afschr.dat
and so on .....
Some payments are not every month (see sheet 1 - Row 10) but in a few months so
Sheet 2 must have
a row with details (cell B4) January , (cell C4) Ardanta2 , (cell D4) amount , (cell C5) afschr.dat
a row with details (cell B4) April , (cell C4) Ardanta2 , (cell D4) amount , (cell C5) afschr.dat
a row with details (cell B4) July , (cell C4) Ardanta2 , (cell D4) amount , (cell C5) afschr.dat
and so on .....
Is there a way to let Excel arrange this automatically in a way that even when data is entered between the Rows in Sheet 1 it calculates everything again ?
I hope somebody can help me with this.
I am just for a week or two busy with simple VBA codes.
Here is a question which goes far above my knowledge :
Attached is a sheet where all my payments are placed (sheet 1).
My wish is to have all details from sheet 1 placed into sheet 2 but in the following way :
(SHEET 1 - Row 6)
Every month I pay "Alimentatie D" so
Sheet 2 must have
a row with details (cell B4) January , (cell C4) Alimentatie D , (cell D4) amount , (cell C5) afschr.dat
a row with details (cell B4) February , (cell C4) Alimentatie D , (cell D4) amount , (cell C5) afschr.dat
a row with details (cell B4) March , (cell C4) Alimentatie D , (cell D4) amount , (cell C5) afschr.dat
and so on .....
Some payments are not every month (see sheet 1 - Row 10) but in a few months so
Sheet 2 must have
a row with details (cell B4) January , (cell C4) Ardanta2 , (cell D4) amount , (cell C5) afschr.dat
a row with details (cell B4) April , (cell C4) Ardanta2 , (cell D4) amount , (cell C5) afschr.dat
a row with details (cell B4) July , (cell C4) Ardanta2 , (cell D4) amount , (cell C5) afschr.dat
and so on .....
Is there a way to let Excel arrange this automatically in a way that even when data is entered between the Rows in Sheet 1 it calculates everything again ?
I hope somebody can help me with this.