1. M

    While loop to move to next row if while condition is met

    Hi Excel gurus, I have put a code together (see below - working code with no copyright, fell free to use it) that analyzes an action plan (excel file with columns for actions, date and time of begin and ending of an action etc.) and creates outlook appointments based on the information on the...
  2. J

    Pivot table calculation question

    I have a pivot table that looks like this Row Label Appointment Email Phone Call Joe 148 302 86 Kate 129 88 303 Ron 157 398 157 Paul...
  3. H

    Count of cell blocks

    Hi all, I am trying to solve a pattern problem and need your help desperately. Is doing my head in. So I have a number of clients that have booked an appointment. As you can see in the file the weeks are at the top. What I want to find out for each customer is: 1. count the number of...
  4. Z

    Problem with BeforeRightClick and referencing a range

    Hi everybody, I am experiencing an extremely frustrating problem at the moment. I am putting together a kind of appointment planner for a clinical professional to fill in. The end version will have 5 weeks (each week has its own worksheet and the layout is exactly the same, very standard -...
  5. S

    Original "start date" of postponed appointment

    Hello, Hopefully someone could help :) I use VBA code that runs through Microsoft Outlook Appointments, and for each appointment - prints a few details - to an Excel table. If I set the start date of an appointment on "01-April-2019", and then postpone that appointment to "12-April-2019"...
  6. D

    Graphs comparing appointment duration.

    Hi I was assigned a project at my work to represent a visual graph on appointment duration. I schedule appointments for my doctor and our boss wants to see if hes completing the scheduled appointments on time. I was thinking of using a visual chart that would compare his actual scheduled...
  7. S

    Return dates from calendar table

    I have a list of client information (columns A-H) and then after that a year's worth of Mon-Fri dates in I3:KU3. Appointment times have been added into the corresponding cell for the client and date. I have cell C1 which calculates the current date. I want to return 2 entries for each client...
  8. S

    how to change code to late binding

    hi folks, I tried to change code to late binding but messed it up at all. I am very beginner, so I ask you. Can somebody help ? I need it because code runs betweeen different stations with different office versions... can you help ? thanks '-------------------------------------------------...
  9. S

    Linking appointment schedule and reminder

    Hello, I have a daily appointment schedule that is going to be shared with 3-4 other people. We all work at the same company but at different locations. The schedule is for a truck washing station for our company trucks. Essentially the different locations are going to send their trucks to...
  10. M

    Use VBA Excel userform to create an annual recurring appointment in Microsoft outlook

    TRying to make a simple Appointment that is recurring annually in outlook. Need the code to include Subject - userform (clientname) Location - userform (Address) all day event mark as unbusy Body - Multiple userform entry (Phone number-email-description) categorize orange Name of it is "Annual...
  11. J

    VBA to get file path and active worksheet then create link to it

    Good morning, Was looking for some help on this small project. I have macro with code that open up an appointment in outlook, but I am looking to auto generate a link to the current worksheet they are in, in the body of the appointment. That way when the appointment comes up they can simply...
  12. L

    calculating opening appointments

    Hello, I have one pivot column of dates that represents doctor scheduled appointments and another pivot column that show appointment times. Since the data only shows scheduled appointments, it does not show the available time each day that are available for open appointments or time in between...
  13. B

    Macro to create Outlook appointment from excel file

    Let me start by saying I know nothing about writing code for macros and I do not have code to start with for what I'm looking for help with. The most I have done with macro coding is modify code for specific file paths or cell designations. Now that I have that out of the way, I'm looking for...
  14. S

    How to share a 2007 Excel file with multiple users on OneDrive

    Hello Everyone! Thank you for taking the time to read my question! I have an excel file that we use to track appointment times at work. I created the file with Excel 2007 (the version on my PC) and shared it so others can add appointments and we do not have any appointment time slots...
  15. V

    VBA Excel Form

    Re: Restrict entry on certain cells based on multiple drop drop-down list******** id="google_ads_iframe_/22152718/MrExcel_InContent_0" title="3rd party ad content" name="google_ads_iframe_/22152718/MrExcel_InContent_0" width="300" height="250" scrolling="no" marginwidth="0" marginheight="0"...
  16. V

    Link cell drop-down list value to excel form

    Hi, Would there be a way to link a dropdown list value to a user form? The appointment column "D" has drop-down list. The drop-down list values are: Confirmed Rescheduled Cancelled If a user selects, "Rescheduled", a pop up form should appear to users to select the following checkboxes...
  17. M

    Counting All Appointment Dates

    Hello All! I'm trying to figure out how to count multiple appointment dates. For example, a client had the following appointments for 2016: 2/5/2016 5/1/2016 7/22/2016 9/10/2016 12/7/2016 <colgroup><col width="64" style="width: 48pt;" span="6"> <tbody> A B C D E...
  18. R

    Slicer not cross filtering on a calculation using a Related table

    Apologies for a likely noob question here, but here's the scenario: The data model I have is relatively simple, but moderately large (about 3.5 million rows and 191k rows in the 2 fact tables). There are 2 fact tables, one with appointments our clients attended (3.5M), and another with...
  19. C

    Advanced Filter between 2 dates and more then one occurence

    Hi, Trying to work through an advanced Filter. How do I complete the filter between 2 dates and also filter if the name is there twice. I have an appointment booking database and want to create an alert if the person has been booked X amount of times in a week(lets say 3) Headings are...
  20. S

    Excel for Patient Appointment Management

    However labor intensive, to what extent can Excel be utilized to effectively manage patient pre-operative clinic appointments (in a near automated manner) whilst also: * controlling the allotment of surgical clinic slots (as a percentage of total pre-operative clinic slots) *...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back