ashish navale
New Member
Hi...I have query in my excel sheet...Its a transport delay tracker which I update as and when I receive email. I have to enter date, emp id, emp name, emp manager name, manager's manager name and place of residence of emp. I want a formula where I will select only the name of emp using drop down list and its emp id, name, managers name, manager's manager name and place of residence will autogenerate in adjacent cells.
I tried with vlookup formula..it works....but the thing is when I select the name from drop down list on the new line the data required is not autogenerated..I manually use ctrl+d then the data comes....I want that I will select only name and rest of the things get autopopulated everytime I enter on new line...plz help me with this query...
I tried with vlookup formula..it works....but the thing is when I select the name from drop down list on the new line the data required is not autogenerated..I manually use ctrl+d then the data comes....I want that I will select only name and rest of the things get autopopulated everytime I enter on new line...plz help me with this query...