+ Reply to Thread
Results 1 to 5 of 5

VBA - Applying Autofill with inserted rows (based on input box) and apply it to other shee

  1. #1
    Registered User
    Join Date
    04-10-2014
    Location
    Brussels
    MS-Off Ver
    Excel 2013
    Posts
    8

    VBA - Applying Autofill with inserted rows (based on input box) and apply it to other shee

    Hello everyone!

    I have a macro that adds news rows based on a input userbox and I'd like to use the autofill to keep the formulas and also same layout if possible.

    Example: I want to add 4 extra products in sheet1. Now, the macro (my button) creates 4 new rows below row #24 (Product1), row #28, and row #32. I want to apply the original formulas in columns O, AB, AO, BB and BO to the new inserted rows. How can I adapt the following code?

    Please Login or Register  to view this content.
    Besides, I want to do the exact same thing on sheet2, but in which values of cells are the same as sheet1 (as already set)

    Thanks for your help!

    Note that I've tried on other forums but it seems I can't upload the links
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,812

    Arrow Re: VBA - Applying Autofill with inserted rows (based on input box) and apply it to other


    Hi !

    If you use an Excel table rather than just a range of cells the formulas are automaticly added when creating new rows

  3. #3
    Registered User
    Join Date
    04-10-2014
    Location
    Brussels
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: VBA - Applying Autofill with inserted rows (based on input box) and apply it to other

    Hi, thanks ! Yes indeed, but how to convert the initial row + the extra created rows into a table in a dynamic way in VBA. Besides, I would need to create as much tables as there are markers (5 in total), right?

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,174

    Re: VBA - Applying Autofill with inserted rows (based on input box) and apply it to other

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    As you are new I will add them for you
    https://www.mrexcel.com/board/thread...heets.1128575/

    https://stackoverflow.com/questions/...nd-apply-it-to

    https://www.ozgrid.com/forum/index.p...ly-it-to-othe/

    Also be aware that experience shows multiple cross posting diminishes your chance of getting help instead of increasing it !
    Last edited by Pepe Le Mokko; 03-31-2020 at 11:07 AM.

  5. #5
    Registered User
    Join Date
    04-10-2014
    Location
    Brussels
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: VBA - Applying Autofill with inserted rows (based on input box) and apply it to other

    Hello, thanks for the info, I'm aware now of this rule. I wanted to upload the links but it seems I can't because not enough posts yet on my side..

+ 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. Replies: 5
    Last Post: 10-04-2017, 01:59 PM
  2. Replies: 1
    Last Post: 10-28-2016, 12:31 PM
  3. Applying formula in a column for new rows inserted ?
    By andyzz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-23-2014, 05:26 AM
  4. [SOLVED] Excel 2010 - Absolute References do Not Apply to Inserted Rows?
    By Ksherer in forum Excel General
    Replies: 3
    Last Post: 11-18-2013, 12:57 PM
  5. Auto applying text to a cell based on another cells input
    By Dutch67 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-23-2013, 09:47 AM
  6. autoFill rows in excel from given input
    By emoney43 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2009, 02:19 PM
  7. How do I autofill colors, based on input of text
    By crizzle in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-16-2008, 03:43 PM

Tags for this Thread

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