Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I would like to put a button on top of each column so that when I click on the button, it will do the basic sort function. I would like to sort each machine by first x (employees who know the job) second Y (wants to be contacted) and third by seniority ( oldest to newest) . A B C D E F G 1 NAME FED1 FED2 N-8 Contact? Seniority Phone number 2 Brian x x Y 8/23/04 234-5678 3 David x N 5/6/00 4 Roger x x N 6/12/02 5 Jeff x Y 5/21/01 6 Chad x Y 9/31/04 7 Serhan x x Y 3/15/02 213-2145 8 Garrett x N 9/10/99 9 Liz x x N 7/7/03 10 Tom x x Y 4/3/00 324-6723 So, Fed 1 will basically look like this: Tom x Y 4/3/00 324-6723 Serhan x Y 3/15/02 213-2145 Brian x Y 8/23/04 234-5678 I, also, would like to go back to the original list after the sorting. Thank you, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to assign a macro to a button | Excel Programming | |||
How do I Assign Macro to a button? | Charts and Charting in Excel | |||
Assign macro to button | Excel Programming | |||
Assign macro to button | Excel Programming | |||
Assign button to run macro | Excel Programming |