Results 1 to 2 of 2

Automatic Date tracking and Auto copy 2 different columns daily

Threaded View

  1. #1
    Registered User
    Join Date
    10-08-2017
    Location
    San Jose, CA
    MS-Off Ver
    Excel 2016
    Posts
    1

    Smile Automatic Date tracking and Auto copy 2 different columns daily

    Hi I'm new here and new to excel. This is my very first excel attempt ever. I found a template for an employee absence schedule online and adapted it to my needs using my crash course online google education.
    I've made a work schedule. I have formatted and formulated all the cells as I'd like them. What I'm trying to do is:

    1. When I cancel someone's work shift during the week I'd like the date of that cancel to automatically appear in the corresponding row of column AJ. And since people could potentially get cancelled multiple times per month I need the date in column AJ to refresh with only the latest date. I need to do this on all 12 sheets.

    2. I would like to create a small table (AM5 to AN30) that would pull the names and times of the people scheduled to work on just one day. I always assign staffing one day ahead. (Except Friday I do staffing for Monday) This would be only Monday through Friday. The information in the table would change daily. I need to do this on all 12 sheets.

    I've attached my spreadsheet with notations and drawings in case I'm not making sense.

    I've spent many, many, many days googling and searching but have not been able to solve this riddle. Any help would be greatly appreciated!

    Thanks!!
    Attached Files Attached Files
    Last edited by speedyblanco; 10-08-2017 at 10:51 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Novice
    By koaatm in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-11-2015, 05:36 PM
  2. [SOLVED] Macro novice look for support - tricky:-)
    By IDO78 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2012, 02:50 PM
  3. questions that aren't really excel questions
    By martindwilson in forum The Water Cooler
    Replies: 1
    Last Post: 03-11-2012, 08:21 PM
  4. Tricky Questions
    By Sceeter in forum Excel General
    Replies: 2
    Last Post: 07-02-2009, 03:03 PM
  5. Please help. Novice.
    By southerncross in forum Excel General
    Replies: 3
    Last Post: 10-05-2006, 05:10 PM
  6. Tricky Tricky episode 2!!!
    By mhax in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-21-2006, 10:15 AM
  7. [SOLVED] Novice needs help.
    By aphwood in forum Excel General
    Replies: 1
    Last Post: 10-04-2005, 03:05 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