vba 2010

Hello. I have an array B2:F9500 dynamic. short example this is what I have this is what I am looking for in other words, I need to sort in ascending order each row. thanks.

Hello. I am in a real trouble here, I understand basic loop ideas, but to loop the macro I am working now, is a hard concept. I am using countif and the sorting function, but my array is to big, so let me show you the macros I am repeating now, and do this more than 2000 times now I understand...

Hi. I am trying to loop the frequency function and I didn't get right the code I write is: Sub LO_FRE() Dim i As Long, j As Long For i = 2 To 54 For j = 10 To 52 Cells(i, j + 1).FormulaArray = "=frequency(R2C" & i &...

Hello everyone. What I am looking is expressed on this frequency function, and also I tried the formulaArray getting of course the same results, but what I really one is to do it with a Loop. (please). {=FREQUENCY(M2:M2744,P28:P34)} Sub VBA_COUN() Range("Q28").FormulaArray =...

Hello Mr. Excel Experts. Sub Basic_Programming() Dim I As Integer, k As Integer lastrow = Cells(Rows.Count, "B").End(xlUp).Row I = 4 '---------------------------------------------------------------[start Cell B4] If Cells(I, "B").Value = vbYellow Then '-----------------[count until yellow is...

Hello, I tried google first and the results so that's why I am here guys. Answer destination is Sheet 2 B4 Place to apply Forecast formula is Sheet 10 B3 what I did Sheet2.Range("I3:N33").Formula = "=trunc(abs(Forecast(sheet10.range(17,B3:B19,$A$3:$A$19))))" Sub ONE_cast()...

Hello, everyone. I am trying to check an entire dynamic array with some conditions. I have a six months data on B2: G the conditions are: IF B5 < B4 and B3 < B5 then ( B3 - 4) else (B3 + 1) and the same for the others columns, C,D,E,F and G I did only the if statements code, what I am trying...

Hello , Hoping you got good weekend . Definitely, I realize this is probably something obvious I'm missing. For [counter] = [start] to [end] DO SOMETHING Next The same formula must be entered in the successive cells columns, but one of the reference in the formula must be incremented By one row...

Hello, Everyone Hoping all be safe. I have a complex task, I don’t Know how to resolve this. EXCELENT code provided by StephenCrump Well-known Member Worked just perfectly Beautiful, for the objective I ask for. Now, the code, loop the TREND formula and compare results with the input data...

Hi. I will try to be Very Clear in the way to explain this. I am comparing sets of 6 numbers what I want is to be sure that I don’t have any Set of numbers equal or duplicates Example If I have in the sheet 2 in a row, the number 6-21-22-30-45-51 I don’t want this ROW, to be duplicate...

Hello, I have been trying to work around this code and do not work, any help please. I have a row of 6 numbers at E2:J2 and one dynamic array at L2:Q I am trying to subtracting each number from E2:J2 from the array and the results at S2:X, just to simplify let think as the row (E2:J2) is...

I have 2 spreadsheets, both have customer ship-to names in them, but they aren't an exact match. I have tried vlookup, index and match etc. to pull the data I need from sheet 1 into sheet 2 , but none will get me the information I need correctly. I am able to copy the name data information from...

Hi, So currently I have a very large spread sheet excel 2010 with control values that pull specific data sets. The data sets are all numerical and use a reference row to be pulled. I currently just pull them from top to bottom from a start point of cell 1. However, I need to change my start...

Hello every one, I had been working in this little problem, and now I got error messages ►next without for◄ I count my for and next and everything are even, so I don't get it, I need some hand here. this code is about input some numbers on column A generate non repiten combination on C:H IF...

Hello, I got a code to generate combinations (I got from here mrexcel), but I don't know where to insert a condition. this code drop down a list of combinations on C:H I would like to add a condition, IF F minus E = B2 then show the combination, I am trying to see just the combinations I...

Hi, I am trying to loop the trend formula in my array A1:F21 and go every four rows on the first col, next col etc. and the results on col I, the code I write have something wrong. any advise please. Option Explicit Sub subtractone() Dim i As Integer, j As Integer For j = 2 To 7 For i =...

hello, I am trying to subtract columns and I write this code but results are complet wrong, is a dynamic array start A1:F250 , I am looking to subtract col B-A results on H, C-B results on I, D-C results on J etc. this is what I tryed. Sub test() 'subtract b-a, c-b, d-c, e-d 'the results on H...

Hi everybody. I have a little array A1:D5 sheet1. I used for next loop for subtractions , can you tell me please how can I use the absolute value and get results on sheet2. this is my code Sub addrows() Dim x As Long Dim y As Long For x = 1 To 5 For y = 1 To 4 Cells(x...

Hi all, I have a document that has multiple sheets, I need to search column A using an inputstring to find all values that match them copy them to the MergedData sheet. It needs to excluding "SUB PAYMENT FORM", "Details" and "MergeData" from the search. It needs to search each sheet starting at...

Hi All, I have the below code which looks to see if a certain cell contains a phrase, either bearing or figure. However since this cell is a linked value there is a chance that an error (#Ref!) will show instead. I thought my code would search for the error and if it did not exist would move...