+ Reply to Thread
Results 1 to 3 of 3

Autofill formulas down rows of new data

Hybrid View

  1. #1
    Registered User
    Join Date
    06-13-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2003
    Posts
    16

    Autofill formulas down rows of new data

    Hello! I am new to VBA. I am having trouble autofilling my formulas down. I add in new data to this spreadsheet each month. I am wanting to copy formulas from column P-AX (all different) down to the last line of data. Right now I have 417 rows, in the future however I will have much more. Please help!

    Sub Copyformulas()
    '
    ' Copyformulas Macro
    ' copy formulas
    '
    
        Selection.AutoFill Destination:=Range("J2:J417")
        Range("J2:417").Select
        Selection.AutoFill Destination:=Range("K2:K417")
        Range("K2:417").Select
        
    End Sub

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Autofill formulas down rows of new data

    Range("J2:K2").AutoFill Range("J2:K417")

  3. #3
    Registered User
    Join Date
    06-13-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Autofill formulas down rows of new data

    But then it will only autofill to row 417, it will likely increase by 100+ next month, and so on..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to autofill formulas to the last row with data
    By ewong in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 09-12-2012, 03:47 PM
  2. Autofill formulas and formats to last data row only
    By hlhought in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-06-2010, 06:10 PM
  3. Insert rows and autofill formulas
    By modytrane in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-05-2008, 10:08 AM
  4. macro - autofill formula to end of data rows
    By ugg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2007, 04:16 AM
  5. Autofill formula to last row with data when rows will be dynamic
    By A Waller in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1