nested for loop

  1. B

    VBA: Nested for loop for a find, copy and paste across two worksheets

    Hi, I need to create a nested loop involving a find, copy and paste but don't know how to. There are two sheets, ws and ws2. In ws, where acad_year is a certain value, the first loop goes through the list looking for pop_fin (the unique id of the record) and matching it up in ws2. However...
  2. S

    excel as a search engine

    Hello, I'm trying to develop a vba code to use excel as a search engine. I have created a cell which bears the input(in sheet(2)). I want excel to search for the input(which lies in the first column of Sheet(1)) , once it's found, take every column corresponding to the result and search for it...
  3. A

    For Each Next Loops Nesting Problem

    I have created a series of workbook that each have several power query queries in them drawing data from other workbooks. The queries have been setup to use a parameter (a persons name) which is provided in a cell of a worksheet that will be hidden and then passport protected. I am trying to...
  4. J

    My code works until I nest it inside another For Loop, am I missing something

    Sub Move3Mo() Dim CL As Range Dim RNG As Range Dim WS As Worksheet Application.ScreenUpdating = False For Each WS in ThisWorkBook.Worksheets Set RNG = Range("c9:C200") For Each CL In RNG If CL.HasFormula = True Then CL.Offset(, 3) = CL.Value ElseIf IsNumeric(CL) = True Then...
  5. S

    Entering values in a list into a macro

    I have a macro that will run through a computation given two inputs on the main tab. I'd like make a matrix in a new tab with all of variable A entries across the top row and the variable B entries down the side column. I'm trying to make nested For loops to run the macro through all the...
  6. N

    Dynamic # of Nested For loops with given min, max, and step #s

    Hello All, I'm working on a problem where I'm iterating through possible combinations of components, I have a sheet that has in Col(F) the Min, Col(G) the Max, and Col(H) the steps; similar to how a For Min to Max step Steps function would work. I've recorded all of these values by Dim...
  7. C

    Reading in average of cells inside a FOR loop

    I'm working within a nested FOR loop. If you notice when I'm Assigning "ECD" I'm trying to average the cells from J (which is row 1) and column 11 to column 12. It keeps on telling me "Application-Defined or object-defined error". Any help would be appreciated. Thanks, Sub copytab() Dim...

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