Auto Fill Values from a cell if a criteria matches

[Hussein_Osseily]

Good day All, 

What is the ideal way to auto fill the data automatically as long as the Truck Ref is the same ? Please check attached photo: 

As you can see , the truck Ref marked in red Square for example are all the same, which means it has the same truck plate , loading time, ATA, ATD, and ETA Dest. Once I manually fill the first line, is there a way for the others to be filled automatically as long as the truck ref matches ? same for the Truck marked in Blue and Green  Thanks for your guidance in this 

[MultiTech]

Few different ways you can go about this, but I think you'd actually be best served by creating another layer in your database above those records.

Anytime you're trying to copy a piece of data from one place into a bunch of other records, generally speaking you're probably better suited to create some sort of parent to all of those child records. Then in the parent you can record that piece of data once, and all of your child records are reference connected so they have access to that piece of data if you need it.