+ Reply to Thread
Results 1 to 4 of 4

Automatically insert new rows to linked worksheet

  1. #1
    Registered User
    Join Date
    11-04-2019
    Location
    France
    MS-Off Ver
    2016
    Posts
    1

    Automatically insert new rows to linked worksheet

    Hi everyone,

    I have looked for this solution on the forum but I could not find anything relevant.

    I have different worksheets in one single excel file. I want one of them to be the master. The latter would compile each data present in the other sheets. Basically, I want that every time I add a new value in one of my subsheets, excel adds it to the “mastersheet”.

    For now, I have them automatically updated but when I insert a new value, it doesn’t update on the mastersheet.

    Apologies for any mistakes, I am new to excel and VBA, but I seek to improve my knowledge.

    Thanks you for your help

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

    Arrow

    Salut !

    Read the yellow banner at the top of this page …

  3. #3
    Registered User
    Join Date
    03-11-2020
    Location
    India
    MS-Off Ver
    2007
    Posts
    1

    Re: Automatically insert new rows to linked worksheet

    hai, Salut,

    I couldn't see the yellow banner.Can any one reply this?
    Ramesh Kumar.S

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

    Re: Automatically insert new rows to linked worksheet

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

+ 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. Replicate the Insert Rows action in a second worksheet, automatically
    By steve@stanley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2012, 03:54 PM
  2. Replies: 1
    Last Post: 07-08-2012, 03:54 PM
  3. Insert new row in a linked consolidated worksheet
    By valle4782 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2011, 07:12 PM
  4. Automatically add rows to linked xcel worksheet
    By dmwllc in forum Excel General
    Replies: 2
    Last Post: 09-21-2009, 02:06 PM
  5. Insert rows to linked spreadsheets
    By Ragdyer in forum Excel Formulas & Functions
    Replies: 48
    Last Post: 09-06-2005, 07:05 PM
  6. [SOLVED] Insert rows to linked spreadsheets
    By Nicole in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-19-2005, 12:05 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