Hi All,
I need to update a drop down based on previous cell..
for example
In sheet 2 i has
product name version
a 10
a 11
a 12
b 10
b 11
b 12
and in sheet 1 as
name version as two columns and if we give name as 'a' then version should get a drop down showing all versions of only product 'a'
if name as 'b' all versions of only product 'b'
its an urgent plz help..
Bookmarks