+ Reply to Thread
Results 1 to 5 of 5

Auto extract data from master list into other sheets based off of month

  1. #1
    Registered User
    Join Date
    01-09-2012
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Excel 2007
    Posts
    54

    Auto extract data from master list into other sheets based off of month

    Hey guys,

    Unfortunately I cannot attach a file because I would get fired for putting information on the internet. In short, I'm trying to auto sort data into spreadsheets based off of the month the project was started. We have a "Master" spreadsheet with all the projects, dates started, and other information which is irrelevant here. I would like the projects and all the data to get sorted into the correct spreadsheet via month. So we have the master sheet, a sheet for january, february, march, etc. For example, if project A was started in January, B in february, C in march; this data would get sorted into the correct monthly spreadsheet (the master sheet will be continuously added to daily). I thought I could figure this out with a vlookup but soon realized I had nothing on my monthly sheets as a lookup value. Any ideas at this point would be great!

    -Dan

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Auto extract data from master list into other sheets based off of month

    The references don't have to be on the current worksheet. For example, there is a vlookup range on Sheet1 and the criteria is also on Sheet1 the following formula on sheet2 will lookup the data correctly on sheet1 and place it on the current sheet2.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If the criteria and vlookup range are on the same sheet, just use a formula like the above pointing to the correct sheet and cell references.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    01-09-2012
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Excel 2007
    Posts
    54

    Re: Auto extract data from master list into other sheets based off of month

    so what do you have to do for the lookup value to be all of one specific month. for example, pull all the projects started in January

  4. #4
    Registered User
    Join Date
    01-09-2012
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Excel 2007
    Posts
    54

    Re: Auto extract data from master list into other sheets based off of month

    you know what, I'm sorry, just realized the project name is to the left of the dates which make a Vlookup difficult to use. I attached a quick spreadsheet
    Attached Files Attached Files

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Auto extract data from master list into other sheets based off of month

    This should give you an idea of how to solve your problem.
    Attached Files Attached Files

+ 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] Auto Fill Secondary Sheets from Master Sheet based on values in a colum
    By hfcamper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2013, 09:04 AM
  2. Auto-populate to Master list from Multiple sub sheets
    By 614984 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2012, 04:18 PM
  3. Replies: 1
    Last Post: 04-13-2011, 04:03 AM
  4. Replies: 8
    Last Post: 12-04-2010, 01:20 PM
  5. how to auto populate data from multiple sheets to a master
    By Fosachy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2009, 06:15 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