Could you post a sample of the original data and/or your spreadsheet so we can get a better grip on what you're working with? Obviously delete any sensitive information or use dummy entries to protect your company.
On Sunday, 10 June 2012 15:50:55 UTC+1, Denice Bollinger wrote: > > 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
