+ Reply to Thread
Results 1 to 1 of 1

Add new row but keep others with formulas

  1. #1
    Registered User
    Join Date
    05-19-2021
    Location
    sunderland
    MS-Off Ver
    365 & 2013
    Posts
    14

    Add new row but keep others with formulas

    Hello all,

    Basically what I want to do is
    What the code do is that it collect data from 3 or more sheets and insert them to another sheet in order to create an invoice. So far , so good.
    FORMA sheet has only the below lines as shown in image 1

    1.jpg

    For example I need to add 20 products (20 rows) but I only have one free row , the starting row 15.
    Then the script to automatically add 19 more rows but keep rows 16-21 (the last 5) untouched as they needed for the totals. So the totals will start at row 36 and rows 15-35 will be filled with data from other sheets. Finally the addedd row will need to have the formula in column D.
    So need to always add more rows depending the amount of products collected from other sheets, not delete the last 5 rows but "push" them down.

    Please Login or Register  to view this content.
    I have attached a sample worksheet


    Thank you all!

    Also posted at https://forum.ozgrid.com/forum/index...row-if-needed/ and https://www.mrexcel.com/board/thread...eeded.1198559/
    Attached Files Attached Files
    Last edited by makispatos; 03-11-2022 at 05:44 AM.

+ 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. Make model faster: convert formulas to text and then back to formulas
    By lucassdm7 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-25-2019, 06:49 AM
  2. Replies: 9
    Last Post: 12-04-2015, 05:19 PM
  3. Poll on - Lots of simple formulas vs fewer but more complex formulas
    By gassiusmax in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-20-2014, 08:51 PM
  4. Using Cell references in file paths for formulas to create dynamic formulas
    By MichaelStokesJr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 11:49 AM
  5. Replies: 5
    Last Post: 09-25-2013, 02:51 PM
  6. Help modifying macro to wrap iferror formulas around existing formulas
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2012, 02:04 PM
  7. Replies: 5
    Last Post: 05-05-2008, 02:22 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