Please help..trying to autofill a link, ='[Timesheet 11-1.xls]Summary'!N$27,
into a column in a worksheet for a year's worth of timesheets. I need the
date to count for each day of the year that matches the link to that
timesheet? For instance... ='[Timesheet 11-1.xls]Summary'!N$27, ='[Timesheet
11-2.xls]Summary'!N$27, ='[Timesheet 11-3.xls]Summary'!N$27..I have just been
copying the first day and then draging it down and going through and changing
the day each month. Any ideas?