+ Reply to Thread
Results 1 to 5 of 5

Inserting a row by keeping the formulas, of another specific row

  1. #1
    Registered User
    Join Date
    02-19-2020
    Location
    Libya
    MS-Off Ver
    2019
    Posts
    13

    Inserting a row by keeping the formulas, of another specific row

    hi to all

    Is their a way so that if a row is inserted in (task/sheet), then all formula's for (row2- data/sheet) appear in the previous inserted row
    - notice that the row has cells from A to T

    data sheet.png
    Task sheet.png
    Last edited by azar3; 08-11-2020 at 01:14 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,428

    Re: Inserting a row by keeping the formulas, of another specific row

    Make the range a Structured Table.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    02-19-2020
    Location
    Libya
    MS-Off Ver
    2019
    Posts
    13

    Re: Inserting a row by keeping the formulas, of another specific row

    Thanks and i have add to my queation A "table photo"

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,556

    Re: Inserting a row by keeping the formulas, of another specific row

    It may help someone to propose a solution if we could see the actual .xlsx file.
    Instructions are given in the banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    02-19-2020
    Location
    Libya
    MS-Off Ver
    2019
    Posts
    13

    Re: Inserting a row by keeping the formulas, of another specific row

    its google sheet i need a script editor, and its unable from the site to make a link

+ 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] SOLVED! copying rows and inserting them while keeping formulas/formatting by vba
    By Fredvonny in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-17-2020, 02:12 PM
  2. [SOLVED] Inserting additonal row and keeping sums
    By carlos1980 in forum Excel General
    Replies: 2
    Last Post: 06-17-2019, 06:05 AM
  3. [SOLVED] Keeping formula the same when inserting a row
    By coach.32 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-04-2016, 08:34 AM
  4. Inserting columns and keeping everything ?
    By horsefish01 in forum Excel General
    Replies: 1
    Last Post: 06-10-2015, 11:57 AM
  5. [SOLVED] Inserting formulas and html code based on specific cell range criteria
    By JohnnyBoyxxx in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-08-2015, 01:23 PM
  6. inserting a row then keeping a formula in it
    By ollielow1993 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2013, 08:43 AM
  7. [SOLVED] Inserting new row but keeping formulae
    By Alex Simpson in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-08-2006, 08:20 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