iteration

  1. G

    Deconding nested ASPX website data into Excel (plus a little javascript)

    I'm trying to pull some data from KY education websites (publicly available, starting at https://applications.education.ky.gov/SRC/Default.aspx). I've done programs before parsing website data, but at an HTML level; ASPX is a new beast for me, and so I'm in learning mode. What I'm wanting to...
  2. S

    Create a List using IF(AND from other tabs

    Is it possible to create a list using data of a different tab using an IF(AND formula? I have 3 tabs. My first tab (Firers) has 4 columns (Rank, Name, Date, Iteration) My 2nd (27SEP) and 3rd (28SEP) tabs have 3 tables each (Iteration 1, Iteration 2, Iteration 3) Basically I'm looking for a way...
  3. B

    Random Numbers with no repeat

    I have a macro which allows me to allocate a random number between 1 and 100 between cells A3 and DV3. The random number selected is never repeated in row 3. The iteration is currently set to only 1 row but the macro currently allows me to add more rows by changing the iteration (I do not need...
  4. A

    Iterations in multiple rows

    So, it's the first time I'm using iteration in excel. When I first tried it out in just one row it worked fine. The problem is that I need to do it in 23 other rows in the same sheet. The iterations work fine in the first row (row 3), but for the remaining 23 rows I only get the #NUM ! error...
  5. P

    Simpler Conditional Row Creation

    I'm currently working on a project intended to simplify the user interface for a table. This table can run in the hundreds of rows and as-is these need to be entered manually line-by-line. We want to create a system in which the table will fill most of its lines based on the information of a...
  6. W

    Loop that tests and stops if condition is met

    My current loop is this: Let x = 0 Do While x < 7 Selection.End(xlDown).Select Range(Selection, Selection.End(xlDown)).Select Selection.Resize(Selection.Rows.Count, Selection.Columns.Count + 8).Select Selection.ClearContents Selection.End(xlDown).Select x = x + 1 Loop I...
  7. O

    Repeat Iteration After X Seconds

    Hello I download results from multiple searches using a loop, but in some cases website reads your search time out. However if I manually re do the search it works. So, I would need to re-do or repeat the same search and then continue as usual. I would like for the code to re-start the...
  8. E

    Excel Iteration Errors

    I am having a very odd problem with Excel 365 Pro+ formula results. I have a complex cash flow modeling worksheet that includes 100+ columns of data in weekly buckets. The formulas in each column are circular/iterative and solve to a minimum cash balance, with the revolver paydown/drawdown...
  9. Y

    VBA Code to use output of 1st iteration in 2nd iteration till reaching optimum solution

    Hi all, I am trying to do genetic algorithm in excel and the 1st trail will result in a recommendation by saying replace parent 1 by child 2 for example. the question is how can i code that in excel, so it will replace parent 1 by child 2 and do another iteration etc, till i reach a number of...
  10. V

    "Shake" the list after one iteration

    Hi all, I'm using an excel file which selects 5 names out of a pool of 50 names. The sheet is such that if 5 names are selected randomly, next time 5 names will be chosen from remaining 45 names. This goes on till 1 cycle is complete. However, in the next cycle which will be iteration 11, I...
  11. J

    Build and Add To an Array

    Hello everyone, Patience with the newbie please. I've been able to find lot's of VBA help here over the years, and am completely stumped with my new task and need help. I have a model, powered by VBA, that runs multiple iterations. Each iteration results in an output like: (the 9 data cells...
  12. T

    Use of "Continue" keyword giving compile time error

    Hi Friends, I am bit confused as this keyword("continue") exits or not in VBA. Then after googling I found this link https://docs.microsoft.com/en-us/dotnet/visual-basic/language.../continue-statement Here they have mentioned the use of this keyword. But when I tried to implement that it is...
  13. C

    Iteration Vs Goal Seek

    I am new in excel. I have a question-what is the difference between goal seek feature and iteration? Regards,
  14. O

    VBA Code to Filter Copy and Paste into New Woorksheet and name each new worksheet with filtered value

    I have a large dataset that I want to filter by values in column A. I then wish to copy all values within that filter to a new worksheet in the same workbook. I wish to name the worksheet after the filtered value. I then wish to repeat this for all unique values within the dataset, each time...
  15. C

    How to find the type of VBA collection?

    Hello everyone! We know how to iterate a Range object because of Google (A range has "Cell" children). We know how to iterate an array of strings because of Google (It has "String" children). But how do we iterate something if we don't know the type of it's children? How do we find it out? I...
  16. D

    Iterating through VLOOKUP matches

    We have two lists of names zipcodes and states. The zipcodes and states are incomplete and first names are inconsistent Christopher vs Chris for example as well as multiple people having the same last name. I want to do a look up on last name, iterate through multiple last names trying to match...
  17. A

    Combinations from Multiple lists

    Hello, I apologise upfront if this is extremely confusing - i have struggled to put it into a nice clear format! however... I have 4 lists of data with each row containing two values; <tbody> Table 1 Val1 Val2 Table 2 Val1 Val2 Table 3 Val1 Val2 Table 4 Val1 Val2 First 52.3 0 First...
  18. N

    VBA - function returns a #VALUE error

    Hey everyone - new to the forum, hoping someone can help me! I have the following code for a function but am getting a #VALUE error when I enter the following arguments: EDate: 10/10/18 RDate: 23/01/18 Rent: 300000 Area: 10000 SC: 10 VC: 15 VG: 1 The function is supposed to iterate through a...
  19. L

    VBA - Iteration to copy & rename files in to a new folder

    Good morning from NZ. I posted a question on this yesterday to do renaming/appending filename. I solved that. The problem I now have is that the code is not copying and renaming files to the new folder and yet when I run to cursor past the filenaming iteration it appears to be doing that. Comes...
  20. L

    VBA - Iteration to copy & rename files in folder

    I have about 30 files to copy to a new folder & rename the files with the date format ddmmyyyy added at the end of the filename before the Ext identifier ie filename.doc? to filename ddmmyyyy.doc? (I also need to modify actual files and want to do this via a macro iteration but one step at a...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top