Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-12-2018, 11:45 PM
ag2686 ag2686 is offline How to auto-populate data based on cell value Windows 10 How to auto-populate data based on cell value Office 2016
Novice
How to auto-populate data based on cell value
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Auto Filter data based on Cell E1 text as Criteria? LearnerExcel Excel Programming 1 03-10-2018 01:36 PM
is sit possible to auto populate a cell based on dates wheddingsjr Excel 6 11-27-2017 11:21 AM
Auto enter data based on formula in another cell? RonLEngle Excel 5 06-30-2017 11:44 AM
Auto populate cell based on certain situations YW3 Excel 10 05-26-2017 02:02 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft