Need help editing my time picking formula please.

[WC2019]

Hello. I'm trying to create a schedule for my concrete pump trucks.

I created a date / time drop down list.

Right now when i pick a time all the cells with my formula show the same time.
I would like to be able to pick a unique time for each cell.

Is this possible?

[dflak]

Each line is going to have to have its own validation. For this, I recommend putting the data into an Excel Table since one of the things an Excel table does is copy down validations automatically as data is added.

I made another table for the validations on Sheet 3.

Here is some information on Excel Tables: http://www.utteraccess.com/wiki/Tables_in_Excel
Here is some information on Data Validation: http://www.utteraccess.com/wiki/Data_Validation

One quick and dirty way to make a drop down list if you have your data in a table is: =INDIRECT("Table_Time[Times]") - the list grows and shrinks as you add and delete data to the table.

[WC2019]

This is awesome!!!!

Thank you kindly!!!!!!