Hi guys, lets say I have 2 worksheets, 1 have the totals of the bank account
per concept and month and in the other one I have the details of those
totals, I wonder if I can do the next: If I double click one of the totals
there is a way to show the detail of this concept for the month?

The totals worksheet is something like that

Concept january February ....
Salary 2050 2000
groceries 250 300
movies 50 75

If you guys need more info let me know

Thanks

Depending on how your data is laid out on the detail page, you may want to
consider using data|pivottable to create the summary.

You can double click on one of the summary cells and see the details that were
used to get that total.


Orlando wrote:

Hi guys, lets say I have 2 worksheets, 1 have the totals of the bank account
per concept and month and in the other one I have the details of those
totals, I wonder if I can do the next: If I double click one of the totals
there is a way to show the detail of this concept for the month?

The totals worksheet is something like that

Concept january February ....
Salary 2050 2000
groceries 250 300
movies 50 75

If you guys need more info let me know

Thanks

--

Dave Peterson

You are right I need to change the way I laid out the data in the detail
worksheet, that why I have another question is possible to create a VBA
routine and get this routine active all the time, for example I create the
next code to update the totals worksheet but I created in a commandButton, I
dont want the user to press the buttom to update the sumary field, I want
this code to run went new information is add to the detail worksheet.

This is the code, and the cell Cells(5, 2) is the name of the concept for
example (Salary). Thanks

Private Sub CommandButton1_Click()
Dim Acumula As Integer
Acumula = 0

With Worksheets("Detail")
Set r = .Range(.Cells(1, 13), .Cells(100, 15))

For n = 1 To r.Rows.Count
If r.Cells(n, 1) = Cells(5, 2) Then
Acumula = Acumula + r.Cells(n, 3)
End If
Next n

End With
Cells(5, 4) = Acumula
End Sub


"Dave Peterson" wrote:

Depending on how your data is laid out on the detail page, you may want to
consider using data|pivottable to create the summary.

You can double click on one of the summary cells and see the details that were
used to get that total.


Orlando wrote:

Hi guys, lets say I have 2 worksheets, 1 have the totals of the bank account
per concept and month and in the other one I have the details of those
totals, I wonder if I can do the next: If I double click one of the totals
there is a way to show the detail of this concept for the month?

The totals worksheet is something like that

Concept january February ....
Salary 2050 2000
groceries 250 300
movies 50 75

If you guys need more info let me know

Thanks

--

Dave Peterson

It looks as though your code could be replaced with a worksheet function.

=sumif(detail!$m$1:$m$100,$b$2,detail!$o$1:$o$100)

(If I read it correctly.)


Orlando wrote:

You are right I need to change the way I laid out the data in the detail
worksheet, that why I have another question is possible to create a VBA
routine and get this routine active all the time, for example I create the
next code to update the totals worksheet but I created in a commandButton, I
dont want the user to press the buttom to update the sumary field, I want
this code to run went new information is add to the detail worksheet.

This is the code, and the cell Cells(5, 2) is the name of the concept for
example (Salary). Thanks

Private Sub CommandButton1_Click()
Dim Acumula As Integer
Acumula = 0

With Worksheets("Detail")
Set r = .Range(.Cells(1, 13), .Cells(100, 15))

For n = 1 To r.Rows.Count
If r.Cells(n, 1) = Cells(5, 2) Then
Acumula = Acumula + r.Cells(n, 3)
End If
Next n

End With
Cells(5, 4) = Acumula
End Sub

"Dave Peterson" wrote:

Depending on how your data is laid out on the detail page, you may want to
consider using data|pivottable to create the summary.

You can double click on one of the summary cells and see the details that were
used to get that total.


Orlando wrote:

Hi guys, lets say I have 2 worksheets, 1 have the totals of the bank account
per concept and month and in the other one I have the details of those
totals, I wonder if I can do the next: If I double click one of the totals
there is a way to show the detail of this concept for the month?

The totals worksheet is something like that

Concept january February ....
Salary 2050 2000
groceries 250 300
movies 50 75

If you guys need more info let me know

Thanks

--

Dave Peterson


--

Dave Peterson

Thanks that's what I was looking for

"Dave Peterson" wrote:

It looks as though your code could be replaced with a worksheet function.

=sumif(detail!$m$1:$m$100,$b$2,detail!$o$1:$o$100)

(If I read it correctly.)