+ Reply to Thread
Results 1 to 3 of 3

Automatically feeding data into another tab when adding rows?

  1. #1
    Registered User
    Join Date
    09-09-2008
    Location
    Nashville
    Posts
    10

    Automatically feeding data into another tab when adding rows?

    I didn't know how to summarize this in the title so please forgive me on that. I'm using Excel 2010 and I consider myself a decent Excel user though far from an expert. Unfortunately I think some people think I'm more of an expert than what I am. So here's my problem:

    We have a spreadsheet that has two tabs. The first tab is a summary tab that takes data from the second tab, which is the "guts" where rows can be added/deleted, and data is entered.

    Now here's the issue. The summary tab only has data from select columns from the more detailed tab. While the detailed tab has perhaps 30 columns, the summary tab has 10 or so. The challenge is to allow it so that when people go in and add rows in the detailed tab, it automatically populates the data from the new rows in the summary tab. I don't know how to do that. I've never known how to do make data automatically populate in another tab if a row is added.

    Basically our managers want the detailed tab to be able to be played with as much as possible (rows added/deleted), with the summary tab just populating automatically when rows are deleted or added. I've only created these types of summaries when the rows are static.

    Any idea how I can make it so this summary tab pulls the data from newly added rows and won't give an error when rows are deleted?

    If screenshots are needed...I can provide. Thanks!
    Last edited by NODAK1979; 05-14-2012 at 11:49 AM.

  2. #2
    Forum Contributor
    Join Date
    03-15-2012
    Location
    Myrtle Beach, South Carolina
    MS-Off Ver
    =IF(Win 7,"Excel 2010","Mac Excel 2011")
    Posts
    104

    Re: Given a new project here at work, please help if possible! :)

    can you get us a sample sheet?

  3. #3
    Registered User
    Join Date
    09-09-2008
    Location
    Nashville
    Posts
    10

    Re: Given a new project here at work, please help if possible! :)

    I attached it here. The first tab is the summary and it feeds from the second. So if I add a row in the second tab how can I make it populate the first automatically?? And how can I make deleting a row in the second tab not cause an error in the first?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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