+ Reply to Thread
Results 1 to 2 of 2

Trying to consolidate a list of names to another worksheet

  1. #1
    Registered User
    Join Date
    03-25-2015
    Location
    PA, US
    MS-Off Ver
    2010
    Posts
    3

    Smile Trying to consolidate a list of names to another worksheet

    mock reg list.png

    I have a list of workers who rang on different registers on any given day (Register list example). I need to use that table to populate a list on another worksheet (Cash register worked list example).

    I then need to have the worked list highlight the cells of the registers they have worked that day.

    I can not figure out how to make the second part to populate, then get rid of duplicates and then use that info to either highlight or not highlight based on registers worked.

    ANY help would be very appreciated!!
    Attached Images Attached Images
    Last edited by NorthernRedwood; 03-25-2015 at 07:44 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Trying to consolidate a list of names to another worksheet

    The forum software prevents some users from being able to view .png files on the forum. Please attach an Excel workbook instead.

    Pete

+ 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. List worksheet names in active worksheet By Excluding Specific Sheets
    By jagadeesh.rt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2014, 10:22 AM
  2. Replies: 1
    Last Post: 01-08-2014, 03:49 PM
  3. Looking for a way to consolidate account list from multiple tabs in a worksheet
    By Lewis2010 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-21-2010, 12:29 PM
  4. Replies: 0
    Last Post: 08-15-2008, 08:24 PM
  5. Code to List all worksheet names (tab names)
    By howard101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2007, 12:51 PM

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