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 =...
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...
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)...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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))))...
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
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 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.