I use this code to start at the the top of the column going down, but the way my data is setup, I need it to start at the bottom and work up.
Sub fillBlanksI()
'Declare variables
Dim FR As Long, LR As Long, i As Long, FillVal As Variant
'Stop screen flicker and speed up code
Application.ScreenUpdating = False
'Find the last row of any column in the sheet
LR = ActiveSheet.UsedRange.Rows.Count
'Loop from row i downwards until we find a value - this is the first filled row and assign its value to FillVal
Using 2003, I'm trying to do the following, data starting in A3, and ending in L3:-
- If A3 is blank, cells have no format - If A3 has a value, with A4 blank, fill is light blue and bottom line solid, top line dotted - If A3 has a value, and A4 does too, fill is light blue, top and bottom line dotted - If H3, which is a date field, is greater than today font is black, if less than today, font is red
Is there anyway to automatically fill the empty added cell after inserting a row without using the fill handle? For example, for a series of numbers: [URL]
2. Drag the fill handle Selected cell with fill handle across the range that you want to fill.
Or running balance: [URL]
2. Extend the running balance formula into the new rows by selecting the last cell in the balance column and then double-clicking the fill handle.
My macro works fine but I'm interested in seeing if I can speed it up. What I'm doing is starting at the bottom and comparing it with the row above and if they match in font color it will fill the top with orange and delete the bottom. This works but usually takes several minutes.
Public Sub ADMINCompareList() Dim varTest1, varTest2 Dim lng As Long, i As Integer, iTest As Integer Application. ScreenUpdating = False Worksheets("ADMIN").Activate For lng = ActiveSheet.UsedRange.Rows.Count To 2 Step -1 If Not Range("M" & lng).Font.Color <> Range("M" & lng - 1).Font.Color Then Goto newrow End If varTest1 = Intersect(Range("J:W"), Rows(lng)) varTest2 = Intersect(Range("J:W"), Rows(lng - 1)) For i = 1 To 14....................................
I need it to autofill just as if you selected range A1 and A2 and double clicked that little square on the bottom right hand side of the cell (so it stopps auto-filling at the last active cell in B)
I currently have this code ( which works perfect ) that was written by someone else. It performs an auto-fill in column "A".
I need to learn how to adjust this code to do it for other columns, but do not know currently.
Maybe someone could highlight of BOLD the adjustments to direct the code to the column.
Sub fill_rows_A_4() Dim arrTmp As Variant Dim lngRow As Long With Worksheets("sheet1") 'adapt arrTmp = .Range(.Cells(1, 1), .Cells(.Rows.Count, 1).End(xlUp)) For lngRow = 1 To UBound(arrTmp) If arrTmp(lngRow, 1) = "" Then arrTmp(lngRow, 1) = arrTmp(lngRow - 1, 1) Next .Range(.Cells(1, 1), .Cells(UBound(arrTmp), 1)) = arrTmp End With End Sub
Working with 2 worksheets in the same spreadsheet. In worksheet A cell F6 is a solution (hex2dec) these solutions are staggered consistently in column F (F6, F9, F12, F15 etc) In worksheet B cell A2 displays workshop A cell F6 details (=ATR!F6) Worksheet B cell A3 Autofil uses (=ATR!F7) I want (=ATR!F9) Worksheet B cell A4 I want (=ATR!F12) How do I condition autofil to follow my chosen sequence ie F6,F9,F12,F15 etc...
when I fill the information into column B on pages 1-31 I would like it to refer to the location names from the loc-mileage sheet and fill in the suggested name as i'm typing.
I thought about doing a drop down but the list is too long and I dont want it to be set to only use the list names, only suggest names from the list.
I need to auto fill quarters but Excel fills years instead. For example I write Q1-11 in cell A1 and when dragging down it fills with Q1-12 rather than Q2-11.
I am trying to figure out how to auto-fill a range. I am summing a range from one tab to another, like A1:A5. I want to autofill the subsequent cells to begin with the cell that follows the last of the previous range, so it would autofill as A1:A5, A6:10, A11:15, etc. how to do this?
I have a macro set up to automatically fill all of the cells in certain columns with the top cell's formula in that column. This is so I don't have to go through and manually "fill down" the formulas into the blank cells after I insert a row into my database. The problems is, though, that the macro sometimes takes a long a** time to run (and uses up a TON of memory...the doc. was 29,000 kb at one point!) because of the amount of rows & columns I have (approx. 5000 row & 34 columns) just one one sheet.
Anyway, is there a way to set up something in VBA to have it auto fill in the formulas in the columns I choose, after I insert a row, with the information that preceeds it?
So, for example, if I insert a row anywhere in my database, excel will know right away that I want that row filled w/ the formulas from the row above it.
I created a database and made one small mistake doing it. The database is infinite amount of rows down and my formula needs to be corrected as such. In the current cells: (C1:C1000) i have the formulas referencing cells $B1, but i need it to reference $B$1. In C2 I need it to reference $B$2, C3 $B$3 and so on. If I autofill, it obviously just keeps the following cells at $B$1 and i can't keep the dollar bill sign.
I need to be able to click on a box and have it fil that box with a check, X, or other fill and have that fill go away if I click on that box again. Can I do that?
my macro simply activates a cell and all i want it to do is to auto fill downwards! its intended to autofill down for about 100 rows but just cant figure it out!
but keep in mind the cell is always going to change so it cant be fixed
i have just finished filling out a 2000 line spreadsheet, on this spread sheet i had a customer number i then had to look up the customer number on our old database to retrieve the address for the customer. Is there any way that for future spreadsheet's i can input the customer number and it will auto fill the address of that customer ?
the columns on my sheet are: customer A/C number Customer Name Customer Address line 1 Customer Address line 2 Customer Address line 3 Postcode
it would save me hours and hours of time digging through the database again.
I have a spread sheet which tracks work we do on certain items. These items (about 200 of them) consist of a 3 or 4 number tracking code (they are all 4 numbers, but some have leading 0's.) This tracking code is entered into Column B and when we cross reference the number to a chart we have we can determine if item is either, "model A," or, "model B."
I want to get rid of that cross reference chart, or rather, I want excel to cross reference for me and automatically fill A or B into Column C, right next to the tracking code.
Is this possible without VBA? It seems like it may be something simple, but i've poked around and have done nothing but make a mess.
I'm trying to set up a multi page report where some of the same information is repeated into a several forms. Is there a way I can set this up to where I type it into the one section and it will auto fill into the other pages I need the same information?
I have an excel spreadsheet like the one attached. My problem is column A has a ton of blank cells. Wht I'm trying to do in Column A is write a formula that fills in the blank cells with the number of the last previous filled in cell. For example the first number is .25 I want to fill in the blank spaces below it with .25 all the way until it reaches a different number which in this case is .219.
Once it reaches .219 I want it then to fill in the blank spaces below it with .219 until it reaches a different number. So basically I'm looking for a formula to fill this in on its own instead of having to drag the cells over and over again manually.
In the excel spreadsheet attached I have in Column D the end result I wish to accomplish.
Michael = Resident Joan = Intern Patricia = Consultant James = Nurse
what I want is every time the name (eg Michael) appears in column A, the title (resident) auto fills in column B. Do I need to put a data source for this?
I'm looking to set up a table in Excel (or possibly Access that is then referenced through Excel). But end goal would be to be able to type in an Item Number and then Excel automatically fills in the Description, weight, price and other information about that item number. That way, I don't have to type in "11108.1" and "Computer Mouse" and "$15.98". I want to only type in "11108.1" and it knows to fill in the other information. Is this possible in Excel? I've searched through many functions and haven't found it so I'm thinking it may require a combination of formulas.
