+ Reply to Thread
Results 1 to 2 of 2

HELP/RUSH: Excel Appointment Scheduler

  1. #1
    Registered User
    Join Date
    PR, USA
    MS-Off Ver
    Excel 2011 MAC

    Exclamation HELP/RUSH: Excel Appointment Scheduler

    Greetings to all,

    I NEED YOUR HELP. Any volunteers for this crazy project of mine? Please

    I'm basically new to this forum and I'm seeking help urgently with a project. I am trying to create an...
    "Automatic-perpetual Appointment Scheduler". This document will help me see the appointments that have been coordinated for each doctor on each day of a week. Now, I have NO idea where to start, how to do it, but I do know what I would like to have on that document. This following model that I will show, is a free template from an amazing creator named Randy Austin, you can find him on youtube.

    Here is an example of what I would like, but far less complicated I think.
    Screen Shot 2014-04-25 at 8.34.44 PM.png

    I am looking for the following features:
    1. Weekly view (that would fit my excel screen and I wouldn't have to drag too much with my mouse), for each doctor (4 doctors with their names on top like the picture) and hours from 8 am to 6 pm with intervals of 30 minutes.
    2. In the area that says "Type" and "Contact name" (as in the picture), I would like "City" and "Patient Name".
    3. I would like the calendar to be perpetual and automatic; that means, to have a button such as a spin button to change the weeks and make them perpetual, so it could go on and on and on.
    4. On top of the dates. I would like to have a spaces to write the information. For example, leave like 4 to 5 rows in blank for this.. What I mean is: Instead of typing the city and name of the patient on the same "cell" in the scheduler plan, and instead of just typing the patient's name and city under the doctor's cell, I would like to have a space in where I could write the name and the city manually, and then with a scroll down box selected 1 of the four doctors. And when finished, just click a label to submit the information, that after pressing it would appear and reflect on the interactive weekly calendar.

    That's really all, I know it's a bit too much maybe. I have no idea how complicated this is, I've been trying to read and watch videos and try, but I failed every single time. I need someone who would like to teach or have patience or would like to help me out. This project is for my work and I was supposed to have it for monday. Now, I have no idea what to do so I am requesting help.

    What you guys think?

  2. #2
    Forum Guru
    Join Date
    Los Angeles, Ca
    MS-Off Ver

    Re: HELP/RUSH: Excel Appointment Scheduler

    Your post title should accurately and concisely describe your problem, not your anticipated solution.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    To attach a Workbook <<<<<<<<
    (please do not post pictures of worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Ben Van Johnson

+ 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. Forum rush hour
    By bebo021999 in forum The Water Cooler
    Replies: 28
    Last Post: 03-08-2014, 08:47 AM
  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. No rush code cleanup help
    By MikeinOK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2012, 02:50 PM
  4. Appointment Scheduler - multiple
    By calebm12 in forum Excel General
    Replies: 2
    Last Post: 03-25-2008, 02:28 PM
  5. 4 column sort... Fools rush in....
    By Neal Zimm in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-09-2005, 09:06 AM

Tags for this Thread


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