You can assign a macro to any object, including a picture.

Insert the picture into your sheet then right-click and "Assign Macro"


Gord Dibben MS Excel MVP

On Sat, 30 Dec 2006 16:47:01 -0800, HELPME
wrote:

Thank you so much T. Valko, works like a dream, I swear I dont understand how
people like you and everyone else who helps people on this board learn so
much about Excel, I use it quite often, but i guess im still just at the
basic level...anyway thanks again, and David Biddulph, sorry if i upset you,
i appreciate your time and effort in helping me, did not think anything was
wrong with starting a new thread, did not want people to tell me to use
filter again since i had tried that, anyway sorry man.

One last question, does anyone know how to link a macro to like a cool
picture button to start it, thanks....

and what is considered advanced or expert level Excel, (pivot tables, using
macros, or all these function formulas??? Trying to get better at all this,
just curious as to what is considered the most advanced Excel stuff you can
do???

Thanks again and Happy New Year


"T. Valko" wrote:

So, you want just the names? And there will be no more than 10 that meet the
condition? Will there ever be less than 10 that meet the condition?

Assume this data is on Sheet1 starting in cell A2:

JOE SMITH 32 YES
DEBBY ALLEN 19 NO
CHRIS JONES 45 YES
TOM WILLIAM 17 YES

Enter this formula where you want the names listed. Enter this formula as an
array using the key combination of CTRL,SHIFT,ENTER (not just ENTER):

=INDEX(Sheet1!A$2:A$5,SMALL(IF(Sheet1!C$2:C$5="no" ,ROW(A$2:A$5)-MIN(ROW(A$2:A$5))+1),ROWS($1:1)))

Copy down 10 rows.

If there may be less than 10 names that meet the condition then use this
version to handle any errors (also arrary entered):

=IF(ROWS($1:1)<=COUNTIF(Sheet1!C$2:C$5,"no"),INDEX (Sheet1!A$2:A$5,SMALL(IF(Sheet1!C$2:C$5="no",ROW(A $2:A$5)-MIN(ROW(A$2:A$5))+1),ROWS($1:1))),"")

Biff

"HELPME" wrote in message
...
Ok I tried the auto filter thing, not working the way i need it, here are
the
specifics again, I have a chart that looks like this on the first
worksheet:

NAME AGE CHILDREN
JOE SMITH 32 YES
DEBBY ALLEN 19 NO
CHRIS JONES 45 YES
TOM WILLIAM 17 YES etc, etc......

OK this list has about 60-80 names on it....now i have another table on
another page that has enough lines for exactly 10 of these names to be
transfered to, I know that there will be only 10 peole from the list who
answer NO to the CHILDREN column, so I wan to be able to somehow pull from
the first list(60 people) and transfer the names of the 10 without kids to
the spot I have on the second page...is this possible, i tried
sort/filter,
does not do what i need it to do, can i use a lookup somehow??? PLEASE
HELP