View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.