+ Reply to Thread
Results 1 to 1 of 1

update formula in a different sheet while adding rows

  1. #1
    Registered User
    Join Date
    07-14-2020
    Location
    italy
    MS-Off Ver
    office 2016
    Posts
    4

    update formula in a different sheet while adding rows

    Hello.
    I have data on Sheet1 in blocks of rows (A3->A40, A44->A81, A85->A122, A126->163, A167->A204) and in Sheet2 I have formulas on those data

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Formula: copy to clipboard
    Please Login or Register  to view this content.



    If I need to add a block of rows to Sheet1 (I can choose if in the beginning, in the middle or at the end) is there a way for having those new rows included automatically in the formulas in Sheet2?

    I've tried adding a block of rows in the middle of Sheet1 but then the formula in Sheet2 was ignoring those new rows...

    I'm attaching an example file.

    Thanks!
    Attached Files Attached Files

+ 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. VBA code automatically update when adding rows.
    By ExcelDude88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2017, 11:21 AM
  2. Replies: 3
    Last Post: 05-03-2017, 09:59 PM
  3. Adding or deleting rows in master sheet and automatically update target sheet
    By RLR31064 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2014, 01:39 PM
  4. Getting Corresponding Values, Update and adding the same to another sheet
    By ar.abdulrashad@gmail in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2014, 04:01 AM
  5. Adding and Deleting rows - update formulas help needed.
    By bperks in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-31-2006, 03:35 PM
  6. Replies: 1
    Last Post: 04-21-2006, 02:15 PM
  7. [SOLVED] Adding Rows To Update A Formula
    By msg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2006, 01:20 PM

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