iteration

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. R

    Multiple Iterations of one formula?

    Right so I've been working on this excel workbook for a couple months and all has been fine, up to now. I have recently been asked to allow for multiple user inputs to the same formula. Now just to let you know, one iteration formula contains approximately 10 worksheets to calculate correctly...
  7. D

    Anyway to bypass iterative solution?

    I have the following relationship x = (A - B*int(x/C)) Is there a non-iterative way to solve for x? By removing the INTEGER function, I can get quite close by not close enough. This is in a large model and it is a little tedious to wait for recalc which is driving the desire to go...
  8. D

    error when adding a single row of record using iteration within a range

    Hi there, I am connecting Excel 2013 to SQL Server 2012, trying to adding a sheet of data to a corresponding table in SQL Server. The code looks like this Dim MoviesConn As ADODB.connection Dim MoviesData As ADODB.Recordset Dim r As Range Set MoviesConn = New ADODB.connection Set...
  9. A

    Need expert help with VB code for copying pasting range values to column iteratively

    Hi, I am looking for some help with developing VB code for the following steps for a financial model: (1) inputting a number into a cell which defines a scenario of assumptions (there are 5 scenarios i.e. scenario 1,2,3,4,5) (2) running a procedure to calculate the Interest during calculation...
  10. J

    error 1004: method 'iteration' of object '_application' failed

    Hi, I've never used macros before, so attempting to debug this thing is like learning a new language. I got the following error when trying to open a document: 1004: method 'iteration' of object '_application' failed When I attempt to debug, I get this code: Private Sub Workbook_Open()...
  11. S

    Financial Statement Modeling - Managing Circular References Using Iteration

    Hello all, I am looking for someone with experience building company financial statement models that use circular references to link the 3 financial statements. I am building a 5-year long-range model and basically the model keeps "blowing up" despite the fact that I turned on the iteration...
  12. P

    Copying down a formula in a variable length range?

    I have a spreadsheet that builds from existing data. The number of rows may vary depending on the data required, but all rows are filled and consecutive. I need to copy down a formula in a column from the top cell, but I can't get the logic to work in getting the Range().Select or...
  13. D

    Return value of every nth column

    A worksheet has data from machine oil pressure readings in column range A:D. The need is for a formula or macro to perform the following; Starting at row 1 copy the values of A:D to F:I every 5th row so that row 1 F:I will contain the values of row1 A:D, row 2 F:I will contain the values of row...
  14. F

    Call back or go back to macro after a user action such as clicking in a cell

    I am about to write a small macro to do a iteration calculation. I would like though for the user to select me a cell so that the macro uses the value in that cell to start calculations. Now, what I think would be the problem is how do I code a "time" or notice an action such as clicking in a...
  15. S

    Loop Referencing Sheet Gets Progressively Slower

    I've had a very intriguing problem for a long time now, and am really hoping someone here can offer me some insight and hopefully a solution. Here's the deal: I have a simple function that pulls in a single cell value, one per row, stores it in a property of a custom type, and then does a...
  16. D

    Iterating through Conditional Format Formulas not working as expected

    I read Bill's "VBA and Macros in Excel 2007" chapter on Conditional Formatting. That said, I'm finding that iterating through the ConditionalFormats.Formula1 collection to not work as expected. For example, a cell shows in the User Interface the following three rules: Rule 1...
  17. H

    Fetch values at the SAME INSTANCE

    I am using DDE feeds in my Excel workbook in Sheet1 in cell addresses K1, M1 & S1 which are constantly being updated with the latest values. In Sheet2, in column D (starting with cell address D1), I am constantly updating with the latest value of K1, whenever a change in value takes place in K1...
  18. N

    Iterative Process

    Dear all, I would like some advice on whether is possible to solve in Excel the following problem and maybe some help with the solution. I have the following equation: Y = I * B(Y) (1) The magnitude of B depends on Y and I have a table of values of B vs Y Y...............B 110.00.......1293.75...
  19. T

    Iteration results recording

    Hello, I am using Excel Pro 2003 version. I have an iteration sheet. I have 2 (two) variables which are Angle and Area. First I set the angle constant and have the iteration solved the area. Then I increase the angle and iteration solves the area for the new input angle. While I am doing the...
  20. B

    Using Solver and "Iteration" together

    I am trying to use Solver to find the maximum investment growth for a business situation. The tricky thing is that one of the constraints is based on a cell that is derived from another cell, which in turn is calculated using Excel's "iteration" feature. To illustrate: One of Solver...

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
Back
Top