+ Reply to Thread
Results 1 to 2 of 2

Excel Client Scheduler Dilemma

  1. #1
    Registered User
    Join Date
    12-01-2011
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2013
    Posts
    7

    Excel Client Scheduler Dilemma

    Hello All

    I have my Excel Workbook attached, it is a calendar type schedule and has to be based
    on the client (left column) each client can have multiple visits per day by multiple employees/times,
    the problems I'm having:

    1) I don't know how to go about it to look up the employee info, I need to
    be able to see hours worked per day & week for the employee?
    2) How can I get the conditional formating to look at 3 fields within a column
    so it highlights duplicate schedule times for the same employee?
    3) What would be the best way to go from one week to another, like a button
    for "previous week" & "next week", or button to copy the whole sheet with new dates?

    The thing is this workbook will be used by a co-worker that has no excel knowledge,
    so it needs to be as easy as possible for the user. I've been breaking my head over
    this, and even dream about spreadsheets now (not a good thing).

    Any input/help would be greatly appreciated. Thanks
    Client Scheduler1.xlsm

  2. #2
    Registered User
    Join Date
    12-01-2011
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2013
    Posts
    7

    Re: Excel Client Scheduler Dilemma

    Anyone any input on any of my 3 problems???

+ 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. Client code for differentiated client price
    By a1b2c3d4e5f6g7h8i9 in forum Excel General
    Replies: 5
    Last Post: 02-27-2014, 12:14 PM
  2. Running Excel from task scheduler. Scheduler doesn't end
    By tony h in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2013, 09:49 PM
  3. One spreadsheet but adding hours on a client by client basis..
    By arthurArthur in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-01-2013, 01:58 AM
  4. PDF Printing of sheets from task scheduler when client is logged off is not working..Help!
    By Mr.FutureCoder in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-14-2012, 03:19 AM
  5. format cell to recall client name-enter a client #
    By cheryl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2005, 06: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