Creating an autofill type function from a data validation box
 

I have a time keeping spreadsheet that has a data validation box to select
the payperiod (ie 01/16/10 to 01/31/10, etc) and I need to have boxes for
time entry with the dates above them auto complete for the date range for the
pay period.

I know it can be done, but I can't figure it out, eveything I try is leading
me to a dead end.

Creating an autofill type function from a data validation box
 

Go back to original thread and see my last reply.


Gord Dibben MS Excel MVP

On Fri, 29 Jan 2010 13:53:02 -0800, SethT
wrote:

I have a time keeping spreadsheet that has a data validation box to select
the payperiod (ie 01/16/10 to 01/31/10, etc) and I need to have boxes for
time entry with the dates above them auto complete for the date range for the
pay period.

I know it can be done, but I can't figure it out, eveything I try is leading
me to a dead end.