drag formula

  1. C

    Drag Formula Down to Cell 100,000

    Good morning community! I have copied and modified the next VBA formula from a YouTube video: Range("G2").Formula = "F2*0.2" Range("G2").AutoFill Range("G2:G16") The formula, of course, works just fine, copying the formula to cell G16. I modified it as follows: Sheet3.Range("I3").Formula =...
  2. J

    Excel VBA macro to drag off the page break preview right side

    Sub Macro1() ' ' Macro1 Macro ' ' ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1 End Sub I have recorded a macro to drag off the direction of page break to right, I have 30+ sheets and I want that the code to run over all sheets except sheet name "Count" & "Raw...
  3. J

    Drag formula and paste as values - VBA

    Hello, I am using the following code to copy formulas down multiple rows (including array formulas that need to be "dragged down") based on a number in column A (ins). Every time there is a number in column 8 (ex: 5) the model will insert 5 rows and drag the formulas in that row (column A:U)...
  4. J

    Find Text (multiple times) in column C - insert array formula - drag down - paste values

    Hello, I am looking for a macro to search column C and insert an array formula one row below every occurrence of "Resource Description." Then, in column A of each row that a formula will be inserted, there is a number - which calculates how many rows to drag this array formula down. After the...
  5. J

    Syntax Error - Insert Column Header (Good), Insert Formula in Row 2 (Good), Drag to Last Row (ERROR)

    Hello, any ideas how I can get the following code to work? I am adding a column called "Value less VAT", then adding in the formula in row 2, then attempting to drag it down to the last row. Everything works like a charm, except the dragging down portion. See details below. Code #1 = my code...
  6. J

    Switch from Absolute reference to Relative Reference - VBA

    Hello, I am working on a model and have VBA code: Copy/paste a range ("A21:L30") from a template worksheet to multiple workbooks that begin with "Labor BOE", multiple times based on a number in cell "L2" For example, if "Labor BOE 1" worksheet has a "3" in cell L2, then it will...
  7. J

    Insert Rows and Drag Formulas Down on Multiple Sheets - VBA

    Hello, I am attempting to get my code to loop through all worksheets that begin with "Labor BOE", find all numbers in column A (beginning in row 2), insert that many rows below the cell with the number, and then drag the formulas down. For example, if cell A10 = 3, then I need 3 rows to be...
  8. A

    VBA- Extend formulas of columns or remove if not needed

    Hello, I am looking for help with a code that will help automate some financial statements. It is a standard tool that has the first year and the last year as an input. Based on the last year of analysis needed, the VBA code would extend (drag) the formulas to the column needed. Also, I built...
  9. M

    Code to drag a subtotal formula to the right

    Hello, I have a list of expenditures that gets longer as time goes on. I used the following code to select the last cell with data in column J, skip two rows down, and add a subtotals formula. Now I want to drag the formula to the right, but can’t seem to set it up right. The starting row...
  10. H

    Need to increment columns in a formula while dragging down...not across

    Greetings all, Is it possible to have a formula, that references a table in another worksheet, increment the column by dragging down? The formula is =MIN(SFLD_Stats!B$3:B$26), and I need to drag it down multiple cells so that it increments to =MIN(SFLD_Stats!C$3:C$26), and so forth. The row...
  11. D

    Inconsistent formula when referencing same cell n times

    Hi all, I hope someone can help me with one that's driving me mad ... I have a workbook with two sheets - "Sheet 1" contains master data and "Sheet 2" in building modified data from "Sheet 1" Sheet 1 <colgroup><col></colgroup><tbody> 3188642010025 3188642037114 3188642146762...
  12. A

    Dragging Conditional Formatting

    So i have a dozen tables and i want to format the colour of each column based on whether a certain cell in each column is greater than 0 So i copied the cells formula out above the table where it would be a number of 0, i then proceeded to conditionally format that column using a conditional...
  13. J

    Nested IF statements and the INDIRECT function in XL2010

    Hi, I am having a few issues with the excel autofill function. Here is what I want it to look like: <tbody> A A1 =IF(Sheet2!A1>=4,100,IF(Sheet2!A1=3,75,IF(Sheet2!A1=2, 50, IF(Sheet2!A1=1,25)))) A2 =-A1 A3 =IF(Sheet2!A2>=4,100,IF(Sheet2!A2=3,75,IF(Sheet2!A2=2, 50, IF(Sheet2!A2=1,25))))...
  14. W

    Drag formula using VBA

    Hi, How would you use cell reference for the following VBA code? Cells(10, 13).Select Selection.AutoFill Destination:=Range("M3:T3"), Type:=xlFillDefault Instead of "M3:T3" I'd rather use a cell reference or some kind of offsetting to drag a formula
  15. L

    Skip X cells when dragging a simple formula

    Hi Lovely all, I'm trying to drag a formula but would like to skip two columns. I have 2 sheets. Sheet 1 with results and the other with column A originals, B actuals, C difference. Sheet 2 has only originals. So if I drag it goes: ='Sheet 1'A2, ='Sheet 1'B2, ='Sheet 1'C2, etc... What I...

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