| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto filter through the Comman Button
Dear Friend. I have an excel sheet. It contains 7 subjects… 01 Serial No 02 Name 03 ID no 04 Expiry Date 05 Job title 06 Jointed Date 07 Vacation There are various employees working under our project, those are 01 Contract Manager 02 Project Manager 03 mason 04 Laborer 05 Plumber 06 carpenter 07 Driver Then…I made Auto filter for job title ….. My Questions … If made Button command from the form toolbar, can I find the Auto filter result… Example…. I would like to know how many employees we have as a mason …. So I am going to make Auto filter then find mason list …………… But I want ………. I want find without Auto filter help ….. If I click the Button command...it want give the list of mason Can I do it? If It’s possible ….. Please reply …how is the way to do that -- irsath ------------------------------------------------------------------------ irsath's Profile: http://www.excelforum.com/member.php...o&userid=35977 View this thread: http://www.excelforum.com/showthread...hreadid=557759 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto filter through the Comman Button
please find the attachment +-------------------------------------------------------------------+ |Filename: EMPLOYEE LIST QUESTION.zip | |Download: http://www.excelforum.com/attachment.php?postid=4970 | +-------------------------------------------------------------------+ -- irsath ------------------------------------------------------------------------ irsath's Profile: http://www.excelforum.com/member.php...o&userid=35977 View this thread: http://www.excelforum.com/showthread...hreadid=557759 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto filter through the Comman Button
You can turn on the macro recorder (ToolsMacroRecord New Macro) while
you manually filter for masons. Then, add a button from the Forms toolbar, and assign your recorded macro to the button. irsath wrote: Dear Friend. I have an excel sheet. It contains 7 subjects… 01 Serial No 02 Name 03 ID no 04 Expiry Date 05 Job title 06 Jointed Date 07 Vacation There are various employees working under our project, those are 01 Contract Manager 02 Project Manager 03 mason 04 Laborer 05 Plumber 06 carpenter 07 Driver Then…I made Auto filter for job title ….. My Questions … If made Button command from the form toolbar, can I find the Auto filter result… Example…. I would like to know how many employees we have as a mason …. So I am going to make Auto filter then find mason list …………… But I want ………. I want find without Auto filter help ….. If I click the Button command...it want give the list of mason Can I do it? If It’s possible ….. Please reply …how is the way to do that -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Auto Filter | Excel Worksheet Functions | |||
| AUTO FILTER NOT CHANGING RESULTS | Excel Discussion (Misc queries) | |||
| Custom Auto Filter default setting should be contains | Excel Worksheet Functions | |||
| Auto Filter in Excel | Excel Worksheet Functions | |||
| Auto Filter Counting | Excel Worksheet Functions | |||
Linear Mode
