Creating an autofill type function from a data validation box

S

SethT

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dates from a data validation 3
Excel Concatenate Form Name to Parse for function 1
stumped on creating dependent data validation lists 1
Data Validation for dates 5
Multiple Column Criteria which deletes all but Highest Value 8
Auto Complete a select from a data validation list 6
Autofill multiple text boxes from a List Box 1
grouping data in a pivot table 2

Top