I am creating a spreadsheet that will need to have dates autofilled. I need each day of the month in sequence with each day entered 3 times to signify 3 shifts. For example:
06/01/07
06/01/07
06/01/07
06/02/07
06/02/07
06/02/07
to the end of each month. There will be a new workbook for each month & there will be several worksheets (tabs) in each monthly workbook. Is it possible for excel to autofill this way?