View Single Post
 
Old 06-12-2018, 11:45 PM
ag2686 ag2686 is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2018
Posts: 1
ag2686 is on a distinguished road
Default How to auto-populate data based on cell value

Hi All,

Need help.

I have list of product name for which the quality test parameters are fixed. I want to know if we have a dropdown for list of products, how to auto populate the associated list of quality test parameters.
E.g.
Product Names: 5711 & 8105

5711 has below list of parameters which should auto populate upon selecting 5711.

Sp. Gr. @ 25C
% MEA
%NH3

8105 has below list of parameters which should auto populate upon selecting 8105

Gardner color
% Polymer Solids
Sp. Gr. @ 25C
Viscosity 25 C (#2 ,30 rpm)
pH @ 25C
Dimethylamine,ppm
Epichlorohydrin,ppm
1,3-Dichloro-2-propanol
2,3-Dichloro-1-propanol
3-Chloro-1-,2-Propanol,ppm
Total Chlorinated Residual,ppm
I.V
Gel Number

I hope I could explain the query clearly.

Thanks You.

Amit
Reply With Quote