finding data from different tables based on header
hello everybody. I have created tables each one with its own name. These tables have fixed values: Height, Width, Length. For each table I have created a sister table. This because the operator can choose whether to use Inch or Cm. Now I need to create an easy system for the operator to input the desired data and get a quick result. What I was thinking about was a sheet where the operator can choose the name of the table, inch or cm, Height - Width - Length (if all 3 sizes are available this could result in a check to see if the package will fit). By doing this "search sheet" I can then hide the tables, this to avoid errors.
Can this be done?
thank you all for any input
|