I would but where the report comes from is broken down into detail and they want a Regional Report, District Report, Company Report, and Detail Report all from the data.
*Denice Bollinger Revenue Controller NewWave Link Phone (662)298-1268 Fax (662) 429-8254 Cell (901)497-9595 [email protected]* * * On Sat, Jun 9, 2012 at 10:31 AM, Barry Etheridge <[email protected]>wrote: > 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 > -- 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
