+ Reply to Thread
Results 1 to 3 of 3

how to show the infos pulled from one sheet into main view, and updating the data

  1. #1
    Registered User
    Join Date
    04-23-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    2

    how to show the infos pulled from one sheet into main view, and updating the data

    I have an Excel spreadsheet that have separate tabs of worksheets with rows of information.

    The concept is to have the information pulled from each separate worksheet into the main overview sheet.

    Concern however is when these separate worksheets have had added/modified rows. How to ensure that the main page will reflect the additional rows?

    The VLookup function will only pull from the range, so it will not pick up information that row is added and will push it out of the data range.

    I am thinking of putting a macro, whereby there will be a button to use to add a row in each worksheet and also to add row in the main overview worksheet so that it tallies and references the information.

    That is just the idea. Being incredibly new to VBA or creating macros, I dont have any idea on how to start writing it. This is the first time I have to do in Excel and VBA.

    If there is anyone who could guide me the way, or give samples to create VBA scripts, your advices will be much welcomed and appreciated.

    Thanks a lot

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: how to show the infos pulled from one sheet into main view, and updating the data

    Why can't you put all the data into one tab, then use a PivotTable combined with a Dynamic Named Range as a data source?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    04-23-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: how to show the infos pulled from one sheet into main view, and updating the data

    Quote Originally Posted by royUK View Post
    Why can't you put all the data into one tab, then use a PivotTable combined with a Dynamic Named Range as a data source?
    Thanks for the reply.
    One thing is, if we add new rows in another sheets, how can it be reflected in the main form? Because, the main sheet is related with entries to the sheets.

    If I m a bit dumb with answers, beg pardon, coz i am totally new to complicated excel functions.

    Thanks again

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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