Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2013
    Posts
    2

    Unanswered: Match and return the value of column

    Hi,

    I'm not good in making codes for VBA macro,thus I need your help, or if you have a much better approach in my problem.

    I have a list of team member with their shifting schedule for the month. each employee was assign to a designated seat. the idea is to see which seats are occupied for the given shift and date.meaning if somebody has taken his rest day for that specific date I selected, that seat must appear empty.

    My idea is count the seats which was tag as "1" for the selected shift and given date. I can do it if i will specify which column only to look at, and it will not work once I change the desired date. please see attached screen shots for ideas..

    any help will be much appreciated.. thanks in advance..
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •