+ Reply to Thread
Results 1 to 7 of 7

Values not updated from another sheet, when insert row

  1. 06-19-2017, 06:59 AM #1
    rajeshn_in
    rajeshn_in is offline
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Values not updated from another sheet, when insert row

    Hi friends,

    I have attached sample sheet.
    I want data from Sheet1 to Sheet2, so that I put formulas in sheet2 like =Sheet1!A1

    But, when I insert a row in Sheet1, then sheet2 formula automatically adjusting, and inserted row values not coming.
    How can I stop that automatically adjust.

    Thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-19-2017, 07:16 AM #2
    TMS
    TMS is online now
    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,495

    Re: Values not updated from another sheet, when insert row

    Try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    copied across and down.
    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

    Reply With QuoteRegister To Reply
  3. 06-19-2017, 07:17 AM #3
    avk
    avk is offline
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Values not updated from another sheet, when insert row

    Why need to insert row in sheet1.
    You create table range in sheet1.
    In sheet2 column "A2" formula
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

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

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

    Look attach file.
    Attached Files Attached Files

    atul

    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
    Reply With QuoteRegister To Reply
  4. 06-19-2017, 07:34 AM #4
    rajeshn_in
    rajeshn_in is offline
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Re: Values not updated from another sheet, when insert row

    Thank you TMS,


    This one working....
    Reply With QuoteRegister To Reply
  5. 06-19-2017, 07:35 AM #5
    rajeshn_in
    rajeshn_in is offline
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Re: Values not updated from another sheet, when insert row

    Thank you AVK.....
    Reply With QuoteRegister To Reply
  6. 06-19-2017, 07:43 AM #6
    avk
    avk is offline
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Values not updated from another sheet, when insert row

    if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved". And please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
    Reply With QuoteRegister To Reply
  7. 06-19-2017, 08:09 AM #7
    TMS
    TMS is online now
    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,495

    Re: Values not updated from another sheet, when insert row

    You're welcome. Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Insert dynamic time contstantly updated
    By Theale in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-16-2017, 04:56 PM
  2. [SOLVED] Insert date whenever cell is updated (not edited)
    By EdwardStephenson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2014, 11:15 AM
  3. I need subtotal row values on Sheet 1 to be updated on Sheet 2 in different cell numbers
    By murphyjohnp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-11-2012, 12:30 PM
  4. how do i insert an auto updated - date
    By moley165 in forum Excel General
    Replies: 2
    Last Post: 04-23-2012, 07:15 AM
  5. Insert values from one sheet to another with a Loop
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-11-2008, 09:17 AM
  6. Rev. Auto Updated when sheet is updated and or entire book
    By frankee_gee in forum Excel General
    Replies: 1
    Last Post: 04-07-2008, 05:05 PM
  7. [SOLVED] Insert Whole Row in Excel when one column is updated from Access.
    By Gordy w/Hi Expectations in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2005, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1