Packaging Database Dashboard

[Packman]

Hello All!!

I'm looking for formulas that will enable the following.

1. perform a search for box dimensions that are similar or over dimensions entered into search fields on the dashboard. The search fields will be the X Y Z dimensions of the box needed.

2. The results must be able to include all possible results while filtering out each dimension that falls below the value entered, for example if the dimensions entered into the search fields are X = 120, Y=58, Z=35 the results must be above each entered value. if any value falls below the entered value it should be excluded.

3. Can it be possible to set a tolerance variable into the dashboard that can fine tune the results. for example if the tolerance value is 12, then the results for the X Y Z dimensions should only display all results that are above the entered values up to the tolerance value of 12.

4. The sheet consists of varying styles (identified by the tabs)of boxes so it will need to work across all styles and populate the results in the dashboard.


The sheet is attached and the results need to display the entire row.

 

[NARAYANK991]

Hi ,

Where are the search box , tolerance box and dashboard ?

Narayan

 

[Packman]

Not created it yet. I was looking for the code only

 

[Packman]

here is a a draft version

 

[NARAYANK991]

Hi ,

Thanks. What is the purpose of the MASTER tab ?

Is the looking up to be done from the data in the MASTER tab , or the data in the individual style tabs ?

Narayan

 

[Packman]

the master tab will be removed, it contains all the original data.

The data in the individual style tabs should be referenced

 

[NARAYANK991]

Hi ,

Thanks. Please check back later ; it will take some time.

Narayan

 

[NARAYANK991]

Hi ,

See this file.

Narayan

 

[Packman]

This is brilliant

If i add more items to each style (tab) will automatically pick them up in the search results?

 

[NARAYANK991]

Hi ,

Yes ; in each worksheet , it iterates through all the items on the tab , till it encounters a blank cell in the BHS column.

Similarly , if you add more tabs , it will scan those too ; the only tabs which are excluded from the scan are the DASHBOARD tab , and the MASTER tab.

Narayan