If I click Lookup button then it has to show relevant fields

kish2007

New Member
Joined
Jan 8, 2013
Messages
1
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
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,118,172
Messages
5,570,672
Members
412,336
Latest member
Tiffany927
Top