+ Reply to Thread
Results 1 to 2 of 2

Creating an appointment worksheet

  1. #1
    Registered User
    Join Date
    11-25-2010
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Creating an appointment worksheet

    Hi,
    I'm trying to generate an appointment worksheet, where I have, say 10 employees and each day split into 15 minute sections. Some appointments can be 15mins, and some as much as 3 hours.
    From the worksheet I want to be able to drag and drop to, for example, give he appointment to another employee.

    The bit after that, i'd like to collate the details of the appointments in a list order so I can export in into an invoicing database, which already exists in Access.

    I've attached a rough idea of what i'm looking for help with
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Creating an appointment worksheet

    Code written for the changes you make in columns P-Q-R-S
    to delete appointement, delete P or S
    Q an R can be changed not deleted after appointement is compleet

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files

+ 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. Creating Meeting appointment
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-12-2017, 09:27 AM
  2. Creating a Copy of a worksheet changes to new worksheet appear in previous worksheet
    By jermique98 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-03-2016, 02:37 PM
  3. Creating an outlook appointment from a spreadsheet
    By sacastiglia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-30-2014, 02:53 AM
  4. Replies: 0
    Last Post: 07-01-2013, 10:19 AM
  5. Creating an Appointment Book for an Optical Shop
    By chaotico620 in forum Excel General
    Replies: 2
    Last Post: 07-25-2012, 12:08 AM
  6. creating new worksheet based on certain value on a worksheet and extracting values
    By deep1blue in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-27-2011, 10:47 AM
  7. Creating an Appointment Calendar
    By vipjd39 in forum Excel General
    Replies: 3
    Last Post: 02-19-2009, 12:06 PM

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