Let us say Sheet1 has 3 column with headers AAA/BBB/CCC
Each column has data to be used as an aid for data entry in other tables (sheets 2,3,4)
Now Each table in these sheets has various columns AND one of these fields is in sheet1
say HD1/HD2/AAA/HD3 etc
The goal is when reaching AAA during data entry in sheet2 a validation list appears that corresponds to AAA in sheet1. User will pick data rather than type it.
Each column has data to be used as an aid for data entry in other tables (sheets 2,3,4)
Now Each table in these sheets has various columns AND one of these fields is in sheet1
say HD1/HD2/AAA/HD3 etc
The goal is when reaching AAA during data entry in sheet2 a validation list appears that corresponds to AAA in sheet1. User will pick data rather than type it.