autofill

Hello, I would like to find out how to autofill a column in another workbook. Here is my code so far: Sub Task1 () Set wb4 = Workbooks("Task1") Set ws4 = wb4.Sheets("Sheet1") 'code lines for copy and paste from Workbook "A" to Workbook "Task1" LstRow = ws4.Range("A" &...

Hello all, The form that I am working with requires me to pull the information from a different sheet. The information is stored with a gap of 38 rows, so standard autofill doesn't work. Is it possible to achieve this? thank you, Oksana

Hey guys, I need some help with autofilling formulas in 5 columns, for example, in range B112:H112, down just one row. To give some context, I have a forecast formula in each of the 5 cells in that row, and with the press of a button, it will generate another row of forecast. So far, this is...

Can someone assist with an Autofill code that autofill dates in column A for a specified year (i.e. 01/01/2019 - 12/31/2019) Thank you kindly

Hi All, I am still learning VBA and currently, I am stuck on how I can copy formula from cell(1,1) on a table to new rows when the table expands (or new columns are added). Here's an example of my setup: Table1: PricesPerFruit <tbody> Fruit Price apple 1 pineapple 2 grapes 3 </tbody>...

Hi all, I have managed to make a loop which looks through all tabs in all files (both tabs and files are unspecified). The code copies a set of data and pastes into a Data Dump file. There is a problem when there is only ONE entry in any tab due to the AutoFill section of the macro. Would...

Hi, can anyone help with this Array Formula? I have formulas that I add to sheet1 through vba that adds rows from columns "A", "B" & "E:K" to columns "AI","AJ" & "AK:AQ" and then apply autofill down to the number of rows required. The formula for Columns "AK:AQ" puts the values in order small...

Hi all, I am trying to get VBA to autofill a formula to the last active cell in the row. I have the below code, which works fine in other macros I've got running but not in this one I'm now working on. It just debugs. ActiveCell.AutoFill Range(ActiveCell, ActiveCell.Offset(0...

Hello all, I have searched and searched but I have not found a thread covering this particular problem. Historically, when I have double-clicked the lower right corner of a cell, it will automatically autofill the cells below and offer a fill handle option menu (Copy Cells, Fill Series, Fill...

Hard to believe I am here for this, but.... here I am Just trying to AutoFill xlFillSeries from Column A to LastColumn Here is where I'm at (I think I'm close?) Application.ScreenUpdating = False With Sheet1 Lc = .Cells(1, .Columns.Count).End(xlToLeft).Column...

Hi, I am trying to autofill vlookup across row, till the last column. My excel have few sheets. Each sheet, number of columns is not fixed. First row has codes. I am getting descriptions for these codes from another sheet into current sheet. I insert a row below to first row, then trying...

I'm trying to Autofill Column X and Column Y with text Where Column Z determines the table length. Starting cell for column Z is "Z3" But the starting point of column "X and Y" are dynamic (due to previously imported information) (Column X & Y is never longer than Column Z). The last filled...

I have part of my VBA code below: Range("W82:X88").Select Selection.AutoFill Destination:=Range("W82:X5500") Range("W82:X5500").Select How can I make the selected range autofill to the last row? Data may contain more or less than 5,500 entries and I would like to make the code...

Hi I am using the below code to autofill the formula however there are blank cells in column C I want the same cells in column in S to be blank... Below code is inserting the formula in all the cells.. Sub insert() Dim LastRow As Integer Range("S:S").EntireColumn.insert Range("S1").Value =...

Hi one and all. I'm new to Excel, so fairly inept with formula etc. I had done a search of questions asked, and found a question that nearly but not quite hit the point. The question posed by 'cmendes on May 18th 2011. What I'm trying to do is to populate cell A1 with AAAA, then autofill...

So in summary i'm entering name initials in a column, and excel appears to be calculating the rest of the coloumn for me, but then deletes it all again. Like a kind of autofill thing. How do I actually make use of this I can't figure it out. In a bit more detail, in column A i have 'Firstname...

Hi, Drop down list value is in D2, based on that value it will autofill range B2:B31. If the value selected in D2 is 24 then Autofill range B2:B31 to 24,48,72 to 720, same as when selected 30 then 30,60,90 to 900. I would like to do this in macro. Thanks

I have a "Form" that I input a customers contact info in such as Name, company, city/state, phone, email. I would like excel to remember the name I typed in and when I go to type that name in again the contact fields will autofill with that persons information. is there anyway to do this or am I...

Hello, I am new to macros and struggling to get a desired range, two adjacent columns (A7,B7), to autofill to the last row of C. Another problem is that I have some data throughout columns A and B and I do not want to overwrite those. So I think I need a loop to get around that? <tbody> Title 1...

Hello, I am trying to find VBA code which would find a header by name and then autofill that column from input box value to the last row. Currently I am using below code to replace value in column PostalCode by value from inputbox. It replaces "United Kingdom" in Column PostalCode with value...