mga master programmers..kahibaw mo onsaon sa excel na masort ang data just by clicking the header??example naa koy table na ang header kay NAMES so after nkoh ug click sa names kay masort ang data under anah na column..thanks daan sa mga mohelp..
mga master programmers..kahibaw mo onsaon sa excel na masort ang data just by clicking the header??example naa koy table na ang header kay NAMES so after nkoh ug click sa names kay masort ang data under anah na column..thanks daan sa mga mohelp..
why not just use filter? i am more convenient of using it. coz aside from sorting you have variety of ways to filter you can apply.
you have to code in visual basic for that and at least naa kay knowledge in basic programming para mka sabot dayon ka on how to do it, sources and references are just around the internet, Google is what you need.
here are some links to help you:
How to: Sort Data in Worksheets Programmatically
Sort Method [Excel 2003 VBA Language Reference]
Similar Threads |
|