+ Reply to Thread
Results 1 to 3 of 3

Generate list on sheet 1 based on data in sheets 2-5

  1. 10-05-2015, 08:15 AM #1
    jmorse6
    jmorse6 is offline
    Registered User
    Join Date
    10-05-2015
    Location
    Boston, MA
    MS-Off Ver
    2010
    Posts
    2

    Generate list on sheet 1 based on data in sheets 2-5

    So here is what I'm trying to do:

    The workbook is for attendance numbers of who is on site based on 4 different groups of people, and acts as a sign in/out

    Sheet 1 is the splash page for data in Sheets 2-5.
    Sheets 2-5 Column A is the by-name roster, Column B is present/not present (0 or 1 displayed as a check or flag icon), Column C is their out code (home, remote site, excused, etc.)

    What I would like to do is create a list on Sheet 1 in Column A of everyone on sheets 2-5 who is currently coded as out. I'm kind of in over my head on this one so any help is greatly appreciated.
    Reply With QuoteRegister To Reply
  2. 10-05-2015, 08:17 AM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Generate list on sheet 1 based on data in sheets 2-5

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
  3. 10-05-2015, 08:30 AM #3
    jmorse6
    jmorse6 is offline
    Registered User
    Join Date
    10-05-2015
    Location
    Boston, MA
    MS-Off Ver
    2010
    Posts
    2

    Re: Generate list on sheet 1 based on data in sheets 2-5

    BOG tracker sample.xlsx

    Names changed to phonetic alphabet for the purpose of privacy.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. copying data from one sheet to named sheets based on list on third sheet
    By Caddman2001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2015, 11:45 AM
  2. Need a code to generate data on sheet 1 based on data from sheet 2, multiple critereia
    By TrinhTran02 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2015, 03:10 PM
  3. Auto-Generate List from reference cells based on data validation list selection
    By BoundCustomDesign in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-13-2014, 11:06 AM
  4. Generate list in new sheet/window based on cell value and command button input
    By nathanmrs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-25-2013, 09:37 AM
  5. Generate list of values in new sheet/window based on cell value and command button input
    By nathanmrs in forum Excel General
    Replies: 1
    Last Post: 10-24-2013, 08:58 AM
  6. Generate Sheet based on other sheets
    By room7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-16-2012, 10:54 AM
  7. Generate a 3rd sheet from data collected from 2 other sheets
    By nicoza in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-09-2009, 07:54 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1