+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Dynamically updating sheet, drawing values from other sheets.

  1. #1
    Registered User
    Join Date
    Melbourne, Australia
    MS-Off Ver
    Excel 2007

    Dynamically updating sheet, drawing values from other sheets.

    Hi guys,

    I'm new here but I did try and look for a similar issue before I went ahead and posted this. I apologise if I missed anything that relates to this.

    I'm trying to create a worksheet that automatically updates and builds a list based on data in other worksheets.
    To explain, I have 10+ tabs. One tab is labled as "Master list" and the other 9 are individual teams in the company I work for. Is there a way I can creat a formula that will dynamically lookup the values of each team and stack them in the master list? I was thinking something like a vlookup and iserror mix. That would look something like
    =IF(ISERROR(VLOOKUP(B36,'Master Contact list.xlsx'!team1,3,FALSE)),VLOOKUP(B36,'Master Contact list.xlsx'!team2,3,FALSE)),VLOOKUP(B36,'Master Contact list.xlsx'!team1,3,FALSE)),

    or something equally wordy. The only problem with using IF is there's only a possible two answers.
    All the teams in other worksheets are named ranges - will this help?

    The more i think about it, the more I'm sure this will either need a macro (which I'm altogether new to) or manual copy/paste action which defeats the purpose.

    Appreciate any help.


  2. #2
    Valued Forum Contributor
    Join Date
    London, England
    MS-Off Ver
    Excel 2010

    Re: Dynamically updating sheet, drawing values from other sheets.

    Can you please attach the workbooks (you can attach a sample/deidentified) so it is more apparent what you are asking for?

    Also, do you mean you have 1 workbook with 10 worksheets or do you mean you have 2 workbooks, 1 you are using as the output and 1 with 10 worksheets of data?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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