+ Reply to Thread
Results 1 to 3 of 3

Automating Data Population Across Multiple Sheets and Filtering Data/Automating Analysis

  1. #1
    Registered User
    Join Date
    07-14-2013
    Location
    are gblests
    MS-Off Ver
    Excel 2011
    Posts
    5

    Automating Data Population Across Multiple Sheets and Filtering Data/Automating Analysis

    Hello all,

    Is there a way I can make my excel file 'automated' so that:

    1/ When new rows of data are added to Sheet1, Sheet 2 automatically updates its 'tiers' data (Sheet2, yellow part and the rows of data) and Sheet 3 produces a new regression (both the values and the graph) automatically? I don't want to have to sort it by tier then copy/paste the data as there is a tonne of data and point 2 will further explain why.
    2/ If I filter Sheet1 according to country or any other filter, then Sheet 2 filters the data remaining per tier and Sheet3 produces a regression on the remaining data automatically?

    If you want you can have 3 sheets (1 per tier) for the 'calculations' part. The setup doesn't matter so long as its automated once data in Sheet 1 is filtered.

    I have attached an example in Excel - all the data is made up so feel free to use it as an example.

    Any help would be greatly appreciated. Instructions would be helpful too so I can do it on my own data.

    Thank you.
    Attached Files Attached Files
    Last edited by lseactuary; 07-14-2013 at 09:36 AM. Reason: Admin asked me to adjust the title

  2. #2
    Registered User
    Join Date
    07-14-2013
    Location
    are gblests
    MS-Off Ver
    Excel 2011
    Posts
    5

    Re: Automating Data Population Across Multiple Sheets and Filtering Data/Automating Analys

    I've managed to solve this

    I need help with something else though - shall I post a separate thread?

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,066

    Re: Automating Data Population Across Multiple Sheets and Filtering Data/Automating Analys

    Yes, if it is unrelated or even a different topic, please start a new thread.

    Also, for the benefit of those who may have been watching this thread, it would be good to share how you solved your query so others can learn.

    Finally...

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    HTH
    Regards, Jeff

+ 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. [SOLVED] Question in conditional formatting Excel Mac 2011
    By so_fistica_ted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 07-06-2013, 05:29 AM
  2. Replies: 3
    Last Post: 08-28-2012, 09:56 AM
  3. [SOLVED] Excel 2007 : Very hard excel question 1,1^1 + 1,1^2 +...+1,1^n - n>20
    By JackBauer in forum Excel General
    Replies: 2
    Last Post: 02-11-2011, 01:39 PM
  4. [SOLVED] hard excel question
    By bp in forum Excel General
    Replies: 3
    Last Post: 04-07-2006, 04:40 PM
  5. Easy question for you, but hard for me.
    By AnimatorElf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2006, 03:09 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