View Single Post
 
Old 11-11-2013, 03:32 AM
s7y s7y is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
 
Join Date: May 2012
Posts: 38
s7y is on a distinguished road
Default 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
Reply With Quote