1. L

    😭I'm doing a vba foodpanda platform, how can I auto-fill the information for the check-out form?

    First, the customer will login through the login userform. Then, they can start ordering the food, afterthat, it comes to the check out form. I don't know how to auto-fill Member ID, Phone no., name, address and current member points from the customer sheet. * Member ID=Ref_ID/ Name = User_Name...
  2. L

    Auto Complete or Predictive text

    I couldn't find exactly what I am looking for, if I missed it please steer me in the correct direction. I have a list of customers >7000 I have those on sheet 2 named DATA in column E, each customer has a grade "A-D", In column D My sheet 1 is a work order log that for each new work order...
  3. V

    VBA Code to automatically fill dates horizontally (not to last column)

    Hello everyone! This is my very first post on but I've been a site regular for many months now. You guys rock! I always find a thread of someone having the same doubt as myself, but I now have a somewhat specific query: I have a data sheet that is updated monthly where monthly...
  4. B

    dyamic array/range - rolling equation

    I have a few inputs in A1:B3: months 20 Price per month 30 cost 180 then in: A5 =sequence(1,b1,1,1) A6 =sequence(1,b1,B2,0) A7 =If(A5#=1,b3,0) This gives me a useful and dynamic table. However, I would add a rolling P&L from A8 for the length of the number of months? Below is the result that...
  5. F

    auto fill with specific interval numbers

    Dear all i want to fill series with specific intervals for example auto fill with 2 interval auto fill with 3 interval 85 85 85 85 86 85 86 86 87 86 87 86 88 87 88 87 89 87 89 88 88 88
  6. N

    Quick manipulation help

    Sheet1, cell B2 is currently blank. I want it to auto fill with whatever is selected on Sheet2 in column A. So cell B2 is something like = active cell sheet 2 kind of formula? I'm assuming this will need to be a macro/VBA code to make it work? Also, if this matters, I have all of Sheet2 from...
  7. Jaafar Tribak

    Worksheet_Change(ByVal Target As Range): How was the Target Range changed ?

    Hi all, Worksheet_Change(ByVal Target As Range) The worksheet change event tells us which Range (Target) was edited but doesn't tell us how. As we know, the user can change a cell either, by editing it with the keyboard, by pasting a value into it ,by drag and drop or by using the autofill...
  8. F

    VBA Autofills Values rather than Formulas

    This is the code I am using: Sub Extract ' Extract the Contract Account Numbers and delete Column A FinalRow = Range("A" & Rows.Count).End(xlUp).Row Columns("B:B").Select Selection.Insert Shift:=xlToRight Range("A1").Select Selection.Copy Range("B1").Select...
  9. G

    Specify Excel increments in autofill

    I'm looking to use excel autofill to complete my formulas in a specific way. My formula is: =IF(Sheet1!E2<$A$2,$A$2,IF(Sheet1!E2>$A$3,A$3,Sheet1!E2)) I drag down to autofill all instances of E2 --> E3 and so on, as I'd like. I also want to drag right to make incremental formulae where all...
  10. 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...
  11. 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 =...
  12. 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...
  13. 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" &...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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