sanket katkar
New Member
Hi all,
Need help to write a macro.
I have 2 different sheets in a workbook.
Sheet 1 has data, from which it will create sheet 2 on click on button.
So logic is, I have values in column D i.e. team name. Based on this team name, it will search for the employee name and copy the data in another sheet let's say Sheet2 were the data will be in one single row.....
I have attached the Excel sheet for reference.
Appreciate your help and support.
Regards
SK
Need help to write a macro.
I have 2 different sheets in a workbook.
Sheet 1 has data, from which it will create sheet 2 on click on button.
So logic is, I have values in column D i.e. team name. Based on this team name, it will search for the employee name and copy the data in another sheet let's say Sheet2 were the data will be in one single row.....
I have attached the Excel sheet for reference.
Appreciate your help and support.
Regards
SK