I'm not sure I understand why you need to do this in code at all. Why do
you not simply have two columns in the spreadsheet for East and West
regions respectively and a simple Sum cell to give you the totals?
On Thursday, June 7, 2012 3:47:47 PM UTC+1, Denice Bollinger wrote:
>
> I am new to this programming stuff please help. I need to collect
> information determined by what is in (Row,3) from (Row, 4) in excel.
> Example would be in (Row,3) is West Region, and in (Row,4) is 1957.23
> and it loops and increments by 1 row every time it loops to work down
> the whole spreadsheet this way. I am not sure how to collect the data
> and return a total for the East Region and West Region. Here is a
> sample of my code.
>
>
> Dim row As Integer
> Dim GrossProfitW() As Double
> Dim GrossProfitE() As Double
>
> row = 2
>
> Do While Sheets("Data").Cells(row, 4).Value <> ""
>
> If Sheets("Data").Cells(row, 3) = "West Region" Then
> GrossProfitW = Sheets("Data").Cells(row, 4)
> Else
> GrossProfitE = Sheets("Data").Cells(row, 4)
> End If
>
> row = row + 1
> Loop
>
> Sheets("Regional Report").Cells(7, 2) = GrossProfitW
> Sheets("Regional Report").Cells(6, 2) = GrossProfitE
>
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
