R
Richie
Hi there,
I have a Excel file with 31 sheets in it - 1 per day. Basically I am
looking for a macro of some sort that would do the following.
[1] Bring up a Data entry screen to enter data on to the required sheet
based on the date (eg. if the date is 17/03/07 then it will enter this data
on to the next blank line on sheet 17.
[2] That at the bottom of the list it will insert the totals for the
respective columns. Obviously this line will move down the list if rows are
inserted.
Here is an idea of what is being entered.
Lment A/C Code Customer Allocation Status Amount Payment Allocate Lment
No
Type Totals
1232 B1412 Joe Bloggs 755.23 Chq
1232 C0667 Fred Fringe 100.00 Cash
1232 F0020 Con Cann 57.50 Cash
912.73
1233 K0005 Ken Jones Clear 50.00 Chq
50.00
and so on.....
DAILY ALLOCATION TOTAL 962.73
962.73
This sheet is then printed with the totals at the bottom of the last page.
What can be done ?
Regards
I have a Excel file with 31 sheets in it - 1 per day. Basically I am
looking for a macro of some sort that would do the following.
[1] Bring up a Data entry screen to enter data on to the required sheet
based on the date (eg. if the date is 17/03/07 then it will enter this data
on to the next blank line on sheet 17.
[2] That at the bottom of the list it will insert the totals for the
respective columns. Obviously this line will move down the list if rows are
inserted.
Here is an idea of what is being entered.
Lment A/C Code Customer Allocation Status Amount Payment Allocate Lment
No
Type Totals
1232 B1412 Joe Bloggs 755.23 Chq
1232 C0667 Fred Fringe 100.00 Cash
1232 F0020 Con Cann 57.50 Cash
912.73
1233 K0005 Ken Jones Clear 50.00 Chq
50.00
and so on.....
DAILY ALLOCATION TOTAL 962.73
962.73
This sheet is then printed with the totals at the bottom of the last page.
What can be done ?
Regards