I'm making a db with 3 linked sheets, sheet K, sheet Y, sheet W to an
principal one P1.
These sheets will gonna get certain data from P1 when a condition of 3
chances is verifyed, these data that are extracted to sheet K, sheet Y, sheet
W, i would like them to be in sequencial order.
I'll gonn give example of what i want:
Sheet P1
A B C D E
1 12-05 Suplier Chance K 10‚¬ 0
2 12-05 Suplier Chance y 0 5‚¬
3 13-05 Suplier Chance K 0 15‚¬
4 14-05 Suplier Chance w 7,5‚¬ 0

in Sheet K, Y, or W these data will be recorded, like example of sheet K:
Sheet K
A B D E
1 12-05 Suplier 10‚¬ 0
2 13-05 Suplier 0 15‚¬

I have a validation list to have only those 3 choices. is this possible?

Thanks