Find & Replace: Amounts, Rates, and Multipliers

Movie Magic Budgeting can find specific values for Amt, X, 4X, or Rate columns based on an exact match to the field's value.

Note: If want to find & replace a specific Global as a part of a calculation in any of these fields, use Find & Replace: Globals.

Find by Amounts, Rates, or Multipliers

• Open the Find tool
• Select Amount (column), X (column), 4X (column), or Rate (column) as the Find type
• Type exact value you are looking for

The Results table below will display any lines that match your search term.

The Account number where the matching detail line can be found is listed first, and may display multiple line results for each account.

The specific value you had searched for will be highlighted in red. The most relevant matches will be listed first.

Note: That these searches expect an exact match of the final value of the cell. If you search for "100" you will not find any matches that result in "1000", nor will you find any matches that have 100 as a part of the calculation that doesn't end up as 100.

Click the Go To arrow button for a result to jump to that account.

Many Results

Only the first 200 matches will be shown by default. If you want to see all results (or select them for replacement) click LOAD ALL in the bottom of the Results table.

Replacing Amounts, Rates, or Multipliers

To replace Amounts, Rates, or Multipliers found in results:

• Click to select one or more of the results using the checkbox at left
  • You can select all matching results in a specific account by clicking the checkbox for the account number
  • You can select all results by checking the checkbox at the top of the table
  • The number of selected results will be reported at the bottom of the Results table
• Enter your replacement value in the Replace with field
• Click Replace

The entire calculation or value for the selected cells will be replaced with your replacement value. Click Undo in the main budget window to undo a replace action.

Note: The entire contents of the Amount, Rate, or Multiplier field is replaced with your replacement value. This will overwrite any Globals used in the field.

Removing Amounts, Rates, or Multipliers

• Select results as you would for replacing them
• Click the TRASHCAN button

The value of all the selected cells will be set to 0 (including clearing any Globals used). Click Undo in the main budget window to undo a remove action.