+ Reply to Thread
Results 1 to 4 of 4

Consolidate data from another worksheet

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    Atlanta
    MS-Off Ver
    Excel 2003
    Posts
    34

    Consolidate data from another worksheet

    Hi,

    Please help me create a formula that will take values from different sheets (Oct & Nov), and cleanly stack them on the master sheet.

    Thanks
    Attached Files Attached Files
    Last edited by jyothijayanna; 09-08-2012 at 12:57 AM.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Consolidate data from another worksheet

    Your sheets are named as 1st Quarter and 2nd Quarter and not Oct & Nov as you have specified. I hope you have uploaded the correct file.

    You have duplicating entries between both the sheets, how do you want the values to show up in the Master tab? Average of both?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    08-17-2012
    Location
    Atlanta
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Consolidate data from another worksheet

    Quote Originally Posted by arlu1201 View Post
    Your sheets are named as 1st Quarter and 2nd Quarter and not Oct & Nov as you have specified. I hope you have uploaded the correct file.

    You have duplicating entries between both the sheets, how do you want the values to show up in the Master tab? Average of both?
    Oh my....I have uploaded correctly.

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Consolidate data from another worksheet

    I would have to recommend VBA for this, especially if you're really going to be adding more sheets, as is typical when we see sheets named after months. This macro, installed into the MASTER sheet module, will do this. Each time you bring up the MASTER on screen from a different sheet, it will recreate the data for you.
    Please Login or Register  to view this content.

    How/Where to install the macro:

    1. Open up your workbook
    2. Right-click the MASTER tab name
    3. Select VIEW CODE
    4. Copy and Paste in your code (given above)
    5. Get out of VBA (Press Alt+Q)
    6. Save the workbook

    Now go to the OCT or NOV sheet and make some edits, then look at the MASTER sheet again, it will reassert the data.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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