vba2010

Hi, I am trying to figure out how to coding a total sales by person, I just upload 3 days info. what I have now and where : as you see for example Derek total per day, I would like the same for the rest. I can think about the pseudocode (maybe) like this start On I3:I10 if B2:B33 names match...

Hi, I am comparing 8 arrays against one, but in order to get some results, the code I have, I need to block many line and live only one unblock, Please any help here. this is the code: Sub com_eight() Dim a As Variant, b As Variant Dim r As Range, i As Range, j As Range, k As Long...

Hi. Column B there are a bin of numbers, column C the frequency of this numbers. In order for me to RANK them, I have to Editing with sort & filter I want to find a real short way to code this, example: So the macro I got is: //////////////////////////////////////////////----COPY AND PASTE...

Hello. Everyone. By the time I requested this code the parameters were fine, now a new approach is require This is the code: Sub third_order_polynomial() Application.ScreenUpdating = False Dim rngStart As Range, rngData As Range Dim Diff1&, Diff2&, NoRows&, NoCols&, i&...

Hello. I have a dynamic array at B2:G, and I am looking forward for code able to populate a new array on S:X base on the row position of every number by row. let me explain. in this images for example The number 1332 if I count from the next row, then this number was four rows away, and number...

Hello everybody. I need a real enlightenment here. I am reading about loops and I founded three lines in different codes that in the places I founded for some reason they explain everything except this symbol. ► * ◄. and the lines that give me hard time to understand are: EXAMPLE 1: 'Cells(8 +...

Good Morning, Happy friday. 5:45 am here in Orlando. I am trying to use CountIf in a loop but I see my logic it is not working this is what I tried in order to figure out the logic so base on this I assume M would be a variable i, MX variable j and A variable k, and base on my start point and...

Hello everyone After searching here, I found some post here about palindromic algorithm, but those do not fit in the idea I am looking for. The close code to the idea I am working on, is this code: Sub SelectDiagonal() Dim myRange As Range Set myRange =...

Hi. First my excel have a problem, meaning I am NOT able to upload the xl2bb, for this reazon I am NOT loading a partial sheet here, sorry, sorry. OK, now my question today is: My data is a ►"DYNAMIC"◄ array at B2:G2800 the computations I am trying is the formulas SUMPRODUCT((mod(B2:G2,2)=0)+0)...

Hi, after hours of searching about sumproduct in the way I got in the code, realize that nothing help me. Please any suggestions here will be appreciated. this is the line of my problem : .Rows(0).Formula = "=SUMPRODUCT(--(" & rngData.Resize(NoRows - i, 1).Address(0, 0) & "=" &...