macro autofill

  1. I

    [Help] Autofill formula then copy-paste-value in a same range

    Hi! I hvae this code: With Sheets("Database") Dim LastRow As Long LastRow = Range("A" & Rows.Count).End(xlUp).Row With Range("I15") .FormulaR1C1 = "=(RC[-4]+RC[-2])-RC[-1]" .AutoFill Destination:=Range("I15:I" & LastRow) End With With Range("L15") .FormulaR1C1 =...
  2. V

    Vba - auto update date

    Hi all, This is my first time posting on here on this forum. I am completely new to VBA and Macros but have done a bit of reading on forums across the web but am still struggling with figuring out all the VBA verbiage. I am looking to write a code that will auto update the cell in column A...
  3. S

    How can I build a macro to auto detect number of rows?

    I am new to excel programming and macros...I am trying to create a macro that will extract data in certain fields and cells, into another sheet. Right now, my approach has been using the recorder functionality to record the steps required to carry out the task. However, I have run into a...
  4. G

    Beginner macro user - Autofill macro required

    Hi everyone, I am using Excel 2007. I don't have any programming experience and I have managed to create a macro that will do autofill once (with numerical increments of one). But now I need a macro that will: Autofill series in increments of one Work in a single column - with unknown number...
  5. D

    Macro to select Accept in Web form

    Good Afternoon, I have made a macro that opens and copies the below web address below into Excel. However I have hit a problem in that you need to tick accept on the two boxes and then select accept down at the bottom of the page before the correct data is uploaded and the data can be copied...
  6. WERNER SLABBERT

    vb to check one sheet against another and copy a field from the third.

    ok lemme Try and explain this. sheet1 has a formatted layout. cell colour functions and so forth. sheet2 has the data table. sorted according to column "A" sheet3 has a blank formatted "template" for data on sheet1 say for argument sake. sheet1 has 190 "pages" of these formatted layouts. each...
  7. M

    Capture data from close workbook

    Dear Sirs, I need to create a code to capture information from a DATABASE.file (closed Workbook) and Sum or Count, based on a several criterias, in the Dashboard.file (Active Workbook). See described below the initial Code. How to count the numbers of non blanks rows from the DATABASE.file...
  8. J

    Macro Help-Autofill Issue?

    I have two columns, one with text (col a) and one with a date stored as text (col b). The code below creates a new column (col c) where it places the text from col a and the "date" from col b together seperated by two dashes, "--". The problem i have is the data set i'm using will not always...
  9. A

    Macro code to circle items when checkbox is checked.

    I have several worksheets with pricing and checkboxes that when checked total the costs up automatically. I have a code that adds the checkboxes for me automatcally and also links them to the proper cell for the true and false at the same time. I've added conditional formatting to make the price...
  10. Z

    VBA Formula Autofill

    Hello - I am currently trying to run a macro and I need a formula autofilled to the end of my data set and the data set will be a different length each time. I'm trying to enter a formula in cell P2 and I want it to copy down all the way until the data ends. Here's what I've tried: Dim...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top