anup.behera86
New Member
Hello Excel Experts,
I am new to excel and while searching for tutorials I stumbled across this great site. It has so many great dashboards, templates and so many many things which are really useful.
Currently I need to create a macro and assign the macro to a button to perform following functionalities. Let me know if it possible because I have been trying something or other for the whole day but still no luck
Scenario is:
There is data table which contains the following columns employee name, employee assigned start date, employee actual start date and employee end date for a company.
I have created a dashboard in a separate sheet where excel will display all the employees details under a list drop down menu. I need to select the employee no. from this drop down menu, then fill the details for employee assigned start date, actual start date and end date details in a form like design. I will then click a button, lets say submit. Based on the employee no selected in the drop down list, excel will find the row for employee no and in the adjacent columns insert the values start date and end date values which I had specified in the form before.
Currently I have completed the following parts of this requirement:
> Drop down list part is done
> Vlookup for searching employee no in the data list is done
> Finding the row position of the employee no is also done
Problem is, I am unable to insert the date values in the adjacent columns for the employee. Can you guys please here? Any suggestions are welcome. Thanks in advance
Regards
I am new to excel and while searching for tutorials I stumbled across this great site. It has so many great dashboards, templates and so many many things which are really useful.
Currently I need to create a macro and assign the macro to a button to perform following functionalities. Let me know if it possible because I have been trying something or other for the whole day but still no luck
Scenario is:
There is data table which contains the following columns employee name, employee assigned start date, employee actual start date and employee end date for a company.
I have created a dashboard in a separate sheet where excel will display all the employees details under a list drop down menu. I need to select the employee no. from this drop down menu, then fill the details for employee assigned start date, actual start date and end date details in a form like design. I will then click a button, lets say submit. Based on the employee no selected in the drop down list, excel will find the row for employee no and in the adjacent columns insert the values start date and end date values which I had specified in the form before.
Currently I have completed the following parts of this requirement:
> Drop down list part is done
> Vlookup for searching employee no in the data list is done
> Finding the row position of the employee no is also done
Problem is, I am unable to insert the date values in the adjacent columns for the employee. Can you guys please here? Any suggestions are welcome. Thanks in advance
Regards
