iterative macro

  1. D

    Automating the Creation of Reports

    Hello all, I am looking to make 1000+ reports based on a template. I have other sheets referencing the target city to update the data they report on. I have a macro that saves the current workbook following the naming convention "Target #". In this case "Austin 1". I will then change the...
  2. D

    Iterative physics function

    Hi, I am trying to make an iterative physics macro, but I have problems figuring out whats wrong. I have had success with a similar macro on another iterative macro earlier. When I try to debug and run cursor to "P1" line, the formula goes blank and the debugger just stops... Macro: Function...
  3. J

    Pull files from folder

    I'm trying to sort through and import a number of bar-delimited text files into an Excel spreadsheet, and running into trouble with the Dir function. My code follows: Option Explicit Dim wbMonthly, wbYTD As Workbook Dim strFileName, strType, strPrd, strFile As String Dim lngBlank As Long...
    • jkwleisemann
    • Thread
    • dir function importing delimited files iterative macro office 2010
    • Replies: 5
    • Forum: Excel Questions
  4. P

    multiple iterations for a pair of goalseeks

    Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+g ' Range("g68").GoalSeek Goal:=Range("g61"), ChangingCell:=Range("g63") End Sub Sub Macro2() ' ' Macro2 Macro ' ' Keyboard Shortcut: Ctrl+g ' Range("g78").GoalSeek Goal:=Range("g71"), ChangingCell:=Range("g73") End Sub hi. i have the...
  5. S

    Find / Replace Iterative Macro

    I'm working to replace scattered values is one tab with values mapped in the second tab. The manual process for this is as follows: select tab 2 select value in column A, row 2 copy value ctrl+F and paste value into "Find what:" field expand options and make sure 'Match Case' and 'Match entire...
    • shantishunn
    • Thread
    • accross sheets find iterative macro replace vlookup and iferror
    • Replies: 3
    • Forum: Excel Questions

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