View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default Evaluate Dates then fill in slots for scheduling

Have a look at this site.
there is a template you can download for free which may help you.

http://www.vertex42.com/ExcelTemplat...-template.html
--
jb


"Freddy" wrote:

The purpose of the code I am searching for is based on scheduling.
Specifically, I need to identify which time slots are available to schedule
work. I would like for the used slots to populate automatically so while I am
on a phone call I can quickly offer a customer an available slot. I have a
multiple row spreadsheet whereby I enter whether work is scheduled, then a
date followed by identifying whether it's AM or PM. Any direction would be
greatly appreciated. I have no VBA code written yet.