hw to fil a column wth sme value depnding on d drop down seletd?

[Swetha]

How to automatically make a cell to be filled by some preset value according
to the drop down selected?

 

[Nick Hodge]

Swetha

Understanding English may not be your first language, I am struggling to
understand what it is you require.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/