autofill

Hi, i have a column with formulas but sometimes manual entry is required to these cells. I have a formula which restores the formulas in the column, but i want it to skip any cells with raw data Range("N2").AutoFill Destination:=Range("N2:N2500"), Type:=xlFillDefault Currently if for example...

Hello, Please help to autofill a range of number in an alternate column then next row with blank rows in between. Just like this screenshot in this link: https://drive.google.com/file/d/18DnV6diWgjRvnz4kURV7whOgF7Z13mzO/view?usp=sharing Thanks in advance!

I have a spreadsheet where i am typing text into cells as follows cell A1 i am typing "timber", into cell A2 "metal", into cell A3 "stone" and other materials into cells below If i start to type into A4 "timber" the cell will autofill from cell A1 when i type the letter t, it fills in the word...

I have a spreadsheet where i am typing into A1 "timber", into A2 "metal", into A3 "marble" etc. If i start to type into A4 "timber" the cell will autofill from cell A1 however if i leave cell A4 blank then start to type "timber" into A5 it will not autofill How do i get excel to ignore the...

Have a block of code that utilized .AutoFill several times. One of them returned a run-time error 1004 autofill method of range class failed. Couldn't for the life of me figure out why the other autofill codes weren't generating errors when they were in the exact same format (and were...

I have a workbook with two worksheets. Let's call them worksheet AAA and worksheet BBB. In worksheet BBB, the following information is in the following cells: A1 ='AAA'!E13 B1 ='AAA'!E14 C1 ='AAA'!E15 When I select the three cells and drag Autofill to D1, I am expecting E16 but it actually...

I have concatenated info from two other columns, in cell A9 and Im having trouble figuring out the VBA to autofill dynamically until the corresponding column B is at its end, which varies. Can anyone assist? This is getting inserted into a larger macro I have.

Hello, I'm trying to simplify the addition of thousands of hyperlinks in a spreadsheet. I have the pictures in a folder and just need to figure out how to get autofill to work with the addressing. The formula below points to the beginning of a series of pictures. How can I drag down and...

I have a sheet that I need to autofill down from a cell value. So item A to repeat its name 40 times starting on sequence 1 than immediately after Item B 10 times and so forth. The order of Item A-D will change as well since sometimes I may want Item B first than Item A etc. Thanks for anyone...

Hello! How can I autofill a cell with the date of the last Monday? Thanks!

Im trying to find an addition to the code blow, which adjusts the 'Selection.AutoFill Destination:=Range("A1:JS5338")' options on sheets 2 and 3 is there a way to identify the last column and last row containing data in "sheet 1" and use this range automatically as the autofill option on sheets...

I'm having trouble in changing my macro to autofill. It is a table and could be 1-5000 lines. This is what I originally recorded on my macro - Selection.AutoFill Destination:=Range("F2:F1511") Range("F2:F1511").Select I tried changing it to : Selection.AutoFill...

Trying to make this autofill dynamic by adding 2 cell variables - any ideas what I am doing wrong? Thanks. With Sheets("Data") .Range("A" & .Range("AD8") & ":" & "A" & .Range("AD10")).AutoFill.End(xlUp).Row End With

Afternoon All, i have an excel doc with a Vlookup formula that has worked fine for a long time, now it isn't working and i can figure out while. the formula works great until i autofill but dragging down the the little square in the corner, then the values all mirror the first value instead of...

Hi all, I have two separate problems. The main goal is to make a list of half-hourly date-times (column B), and then match a bill invoice to these dates. 1) Problem 1: I typed two date-times and then autofilled below them to keep half-hourly increments. However, they don't stay half-hourly...

Hi, I am trying to create a macro to make my life a lot easier each month. I download an excel file and need to add to formula's to each row. However the amount of data on the spreadsheet will vary month to month. So what I need to do is have VBA put the formula in cell S2 and then drag it down...

Hi! I'm trying my hand at editing a macro I recorded, and not having much luck. I just need to find a way to autofill the date just down to the last populated row instead of to the bottom of the page. Here's the pertinent section: Columns("C:C").Select Selection.InsertShift:=xlToRight...

Hi All I would like to do a sum for multiple cells until the row before the last row as the last row is an auto sum of the whole column. The sum is: B4 = sum(N4,R4,AH4) autofill up to the second last row (number format) C4 = sum(O4,S5,AI5) autofill up to the second last row (currency format)...

Hi, I am currently having an issue with some code that I havenever experienced before and can’t figure out the cause , wondering if anyonehere has had the same issue & possible fix. I have some code that bring formula’s down to the last cell acrossa worksheet (code below) Dim lastRow As...

The latest Excel release appears to have a very simple yet potentially critical bug with autofill. Values will lose or gain 0.0000000000001 or <del style="box-sizing: inherit; color: rgba(0, 0, 0, 0.6); border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing...