I've got a Sub which runs successfully until the point where a formula needs to be dragged down to the rest of the column.
In short, data is copied from column H (cell 15 downwards) in the "Main Sheet" of a file called "Main Sheet" and pasted into cell DC15 of the same sheet.
This maybe a very simple question.
I have 1 column.
I want the pattern to continue i thought i could highlight the 4 cells and fill down and it would look like the below but it does not let me it just duplicates the values in the first 4 cells. I...
Hello and thank you for the help
J3=215, J4=214 and so on to J93
N3=215 and conditional formatting for this cell has 3 rules
Cell Value < J3 (green format) applies to =$N$3:$N$5
Cell Value = J3 (yellow format) applies to =$N$3:$N$5
Cell Value > J3 (red format) applies to =$N$3:$N$5
I'm trying to fill down two columns with a VLOOKUP function. The basic VLOOKUP function works, but when I try to use the TEXT function to ensure the date gets it is "looking up" is returned as m/dd/yyyy instead of a large integer, VBA won't even let me continue writing the code before it tells...
I've looked everywhere and maybe I just wasn't wording my search properly but I cannot find a solution to a problem I have on a daily basis. I'm looking for a macro that will do the following:
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
I have Column AH which has every two rows merged (AH10:AH111,AH12:AH13) etc. In column AQ I have an equation that I want to be able to fill down that references column AH. My issue is that the first cell in Column AQ references the merged cell, but the second references only half the merged...
I'm trying to create a fill down macro for the range D4:D5028
Here's the code I have so far:
I got most of this online.
' FixParent Macro
Dim lastrow As Long
lastrow = Range("D4:D5028").End(xlUp).Row
I have a column that includes two letters, EZ, then the date, followed by rack number, for labels.
These decrement down the column as such:
EZ12151736, EZ12151735, EZ12151734....
When the last two numbers reach 01, it starts over with the previous day:
I have this done...
After filtering for 2017 data in column C the following formula:
With ActiveSheet.Range("N2:N" & Cells(Rows.Count, 2).End(xlUp).Row).SpecialCells(xlCellTypeVisible)
.Cells.FormulaR1C1 = "=IfError((RC[-2]),0)"
I have this code to insert my formula and fill down the column.
wsFirst.Range("AQ3:AQ" & Cells(Rows.Count, 1).End(xlUp).Row).Formula = "=IF(P19=1,1,0)"
The problem is that it stops at 101'st row. I think this is related to the fact that before i created the range "ipi" with 101 values...
please, I ask for some support at Power BI, I'm new at that fabulous application. I got data from a XML file >> then edit >> as shown I ask for how can I drill or split each line in an autonomy row then fill down the other rows, is that applicable in Power BI, I hope that, please :)
I have the code below. I'm trying to copy the formulas down from 'A2' but when I run the sub it will repeat the header line. What am I missing?
Dim last_row_non_grad As Long, non_grad_count As Integer
Dim curSheet As Worksheet...
In my Excel sheet there are ABCDE columns
D column is filled in with data. & I am filling down BCE columns by selecting & Pressing CTRL+D. I want a VBA macro to do this, the sheet is of 1000 rows.
data looks like this
I want the data to be like this
This will be a simple one for somebody out there but here goes.
I have 3 tabs (Summary, sheet 2, sheet 3)
All three tabs have the same columns in the same order. However, there is only data in the summary tab at the moment.
Name, Address, Town, Telephone number
I do not know how to write code, but only how to record macros. I have 3 adjacent cells with vlookup formulas (E2, F2, and G2), and i want the formula to fill to last row with data. Each time the macro is ran, it will start in the same spot (E2:G2), but will have a different end point...
Could anyone please help me with my code? I don't know what I'm doing wrong, it works perfectly on one file (Remision), but for some reason it won't work on the other one (CI Fill).
It is a simple userform that helps creating some documents. I attach them for your reference.
So I have all this rainfall data by the hour in one sheet, and I want to sum it up by day onto another sheet.
Is there a way for me to put the sum formula into a cell, referencing and summing the 24 individual cells from the other sheet, then just fill the formula down to each consecutive row...
I have been looking/trying various bits of code to insert a row on a large protected sheet. I have also been recoring various stages, but cant get the result I am after and think I might be overcomplicating metters.
Large Excel sheet with A:Z and 1-100 hidden, full of calculations. The...
I have a spreadsheet that fills down each column. The problem with columns E & F is that they contain numbers, and each row increases by 1, i.e. 123 Adam St, 124 Adam St, 125 Adam St, etc. I need VBA to find the last row of data in that column, copy it, then fill down without the number...
I'm trying to copy some rows down, based on cell values, and this approach was recommended. However, I'm getting a compile error -problem with the last ")"
For context, StartRow = 16, and NumberToCopy = 826. Therefore, I'm trying to copy row 16 down to row 826.
Can anyone see the...