Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Is possible to modify this program for have the divided total for months in the "D" column? Regards. Marcello For example: |A |B |C |D | Page | Date | Import | Total | 1 | 10/04/2005 | 32,50 | | 1 | 12/04/2005 | 12,50 | 45,00 | 1 | 11/05/2005 | 52,50 | | 1 | 30/05/2005 | 10,50 | 63,00 | 1 | 10/06/2005 | 19,50 | 19.50 Sub EnumSheet1() Dim sh As Worksheet Dim Name As String Dim I As Long Dim DataDoc As Date Dim ConPag As Currency I = 1 With Sheets("sheet1") For Each sh In Worksheets If sh.Name < "Sheet1" Then DataDoc = sh.Cells(21, 4) ConPag = sh.Cells(85, 7) I = I + 1 .Cells(I, 1) = sh.Name .Cells(I, 2) = DataDoc .Cells(I, 3) = ConPag End If Next End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding Regressive Months Totals | Excel Worksheet Functions | |||
Adding Progressive Months Totals | Excel Worksheet Functions | |||
Add monthly totals of months forward | Excel Worksheet Functions | |||
Looking for certain months and summing the totals | Excel Worksheet Functions | |||
Add Totals for Last 12 Months | Excel Discussion (Misc queries) |