The intent is to extract the work schedule data from a database, paste it into the cells on the Data worksheet, and have the report automatically generated (i.e., the headcounts by half hour and the dates would automatically be generated - there would be no need to key in dates). I am trying to automate this process as much as possible for the end user. Thanks again for your help.