software

Hi

I have several sheets that contain the following data: eg column a has
brk and column b has a town and column c has a value. Is there any way
I can sum the total for column a and column b in a another sheet

Thanks for any help/--
david72
------------------------------------------------------------------------
david72's Profile: www.excelforum.com/member.php...foamp;userid=7980
View this thread: www.excelforum.com/showthread...hreadid=543614
How do you mean sum them in another sheet?
Do you want column quot;Aquot; totaled and column quot;Bquot; totaled or do you want
the total of column quot;Aquot; PLUS total of Column quot;Bquot;?

david72 Wrote:
gt; Hi
gt;
gt; I have several sheets that contain the following data: eg column a has
gt; brk and column b has a town and column c has a value. Is there any way
gt; I can sum the total for column a and column b in a another sheet
gt;
gt; Thanks for any help/--
bgeier
------------------------------------------------------------------------
bgeier's Profile: www.excelforum.com/member.php...oamp;userid=12822
View this thread: www.excelforum.com/showthread...hreadid=543614
If column a and column b are the same. I would like to sum the total of
column c.

Thanks--
david72
------------------------------------------------------------------------
david72's Profile: www.excelforum.com/member.php...foamp;userid=7980
View this thread: www.excelforum.com/showthread...hreadid=543614
I apologize, I missed the last clause of the first phrase in your post.
(I claim temporary stupidity)Code:
--------------------
Sub TotalC()
Dim intRowCounter As Integer

intRowCounter = 1

Do Until Cells(intRowCounter, 1) = quot;quot;
If ThisWorkbook.Worksheets(quot;Sheet1quot;).Cells(intRowCoun ter, 1) = ThisWorkbook.Worksheets(quot;Sheet1quot;).Cells(intRowCoun ter, 2) Then _
ThisWorkbook.Worksheets(quot;Sheet2quot;).Cells(1, 1) = ThisWorkbook.Worksheets(quot;Sheet2quot;).Cells(1, 1) ThisWorkbook.Worksheets(quot;Sheet1quot;).Cells(1, 3)
intRowCounter = intRowCounter 1
Loop
End Sub
----------------------
bgeier
------------------------------------------------------------------------
bgeier's Profile: www.excelforum.com/member.php...oamp;userid=12822
View this thread: www.excelforum.com/showthread...hreadid=543614