Hi friends,
In my excel two sheets are there one is employee list having EMPCODE, Name, DEPT Code. In my second sheet we are showing Department name, no.of employees columns. We are displayed no.of employees count from first sheet. For ex. SALES department having 30 employees. Now i want to put one button. If I click that button then it has to show only 30 employees details in first sheet. How to do this. Can you please share your views at earliest.
Regards,
Kishore Kumar.G
In my excel two sheets are there one is employee list having EMPCODE, Name, DEPT Code. In my second sheet we are showing Department name, no.of employees columns. We are displayed no.of employees count from first sheet. For ex. SALES department having 30 employees. Now i want to put one button. If I click that button then it has to show only 30 employees details in first sheet. How to do this. Can you please share your views at earliest.
Regards,
Kishore Kumar.G