1. E

    VBA Perform Autofill formula in specified column name/location

    Hello, I have a VBA macro that will insert a new column (titled updated col..) to the right of the specified column name. Then I use a VLOOKUP and autofill in the new column to provide the updated values. The column location of the updated column is variable/dynamic. How can I make the autofill...
  2. G

    Autofill the values from found columns

    Hi all, I am trying to find two columns by their name in a sheet, viz. Column "Fruits" and column "Vegetables" and then trying to paste these columns's merged value in a new column. My code Sub Merge_B&C() Dim WrkBk1 As Workbook Dim WrkBk2 As Workbook Set WrkBk2 = ActiveWorkbook Set WrkBk1 =...
  3. C

    VBA copy LEFT function / formula down all cells in column

    Hi guys! Long time reader, first time poster. Getting very frustrated with my VBA so any help is appreciated. In my worksheet "Paste Data", I have a string of text in column G and need to use the LEFT formula to find and copy the text before the character " - " into column H. My VBA code...
  4. N

    VBA For Each Formula & Autofill

    Dear All, Hello, I've just learnt how to use VBA and still new on it. I made a formula below, where it works perfectly for my sheet. Range("$AE$2").FormulaR1C1 = "=IF(RC[-25]=""V6"",LEFT(RC[-11],LEN(RC[-11])-1),RC[-11])" Range("AE2").AutoFill Destination:=Range("AE2:AE" & Range("F" &...
  5. P

    AutoFill Formula from ActiveCell till the last cells of other columns having data.

    Hi there, My Name is Prathik. I'd like to apologize if this question has already been answered. I didn't find anything about this anywhere on the internet. So posting it here. Please assist. So I'm writing this code wherein my macro writes a formula in E2 (Range A To D already has data). Then...
  6. A

    VBA Autofill horizontally referencing a variable date in a cell

    I have the below vba to autofill the formula between J17 to ACP17 based on if there is data in column E. Range("J17:ACP17").AutoFill destination:=Range("J17:ACP" & Range("E" & Rows.Count).End(xlUp).Row) Works fine, but J17 to ACP17 hold formulas that relates to a row of sequential dates...
  7. M

    Vlookup in Excel VBA for Data Entry

    HI Excel Expert , Request your valuable help in solving the below error . PS: Am new to Excel VBA coding . I have got 3 Sheets in the attached workbook “Just combo V2” Download link : Just combo V2.xlsm Sheet 1 Sheet 2 =”School” in which Cell A1 : A14 Contains list of schools Sheet 3...
  8. U

    VBA FormulaArray Syntax/AutoFill/Set Ranges

    Hi all I am trying to do a few things here with VBA: Here's the source Worksheet named MoCMatrix ABCDEFGHIJKLMNOPQRSTUVW1HELPER ROW > Structural Integrity-MoCStructural Integrity-Substantiation DocumentStructural Integrity-StatementFlammability & Smoke-MoCFlammability & Smoke-Substantiation...
  9. A

    Autofill predifened values help !

    Hello, I want to fill cell e1 with value "GOLD" when I fill cell a1 with value "GL" Similarly if I fill a2 with value "SL" I want the cell e2 to be filled with value "SILVER" I WANT TO FILL A COLUMN CELLS WITH SOME PREDIFENED VALUES AND I WANT CELLS IN E CLOUMN TO GET FILLED WITH ASSOCIATED...
  10. L

    Macro to autofill cells based on last cell or final row data in adjacent column

    I'm trying to create some automation in a macro--see attached picture. The automation includes adding a formula in cell G2 =CONCATENATE($F2,"")--then autofill this formula down column G to the last cell or final row in column F. I don't know how to reference the adjacent column when...
  11. M

    Excel VBA Dynamic Autofill

    The Column has entries as shown below. AA BB CC I want to auto fill entries like all cells in the column between AA and BB get auto filled by AA, all cells in the column between BB and CC get auto filled by BB and so on. This should continue till the end of last row...
  12. M

    Autofill in another workbook

    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" &...
  13. O

    Autofill with gaps

    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
  14. E

    Autofill down 1 row

    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...
  15. A

    Autofill dates for specified year

    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
  16. R

    Need help on code to copy formula from one cell to other cells in the row on a dynamic table

    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>...
  17. E

    Ignore Hidden Sheet & AutoFill Fail Safe

    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...
  18. P

    VBA Array Formula

    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...
  19. C

    VBA - Formula AutoFill

    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...
  20. C

    Fill Handle Menu Replaced by Quick Analysis Menu

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

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

We've detected that you are using an adblocker.

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
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 "".
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.
Go back