LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default How to put a button on a cell and assign macro to it?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to assign a macro to a button WANNABE Excel Programming 2 October 2nd 06 08:25 PM
How do I Assign Macro to a button? BellExcel Charts and Charting in Excel 4 May 20th 05 07:21 PM
Assign macro to button Bob Phillips[_6_] Excel Programming 0 May 24th 04 04:27 PM
Assign macro to button Frank Kabel Excel Programming 0 May 24th 04 04:03 PM
Assign button to run macro jamie85[_5_] Excel Programming 8 February 3rd 04 01:44 PM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"