Creating an Index when different names are in non-simultaneous rows

**torontoguy** · 02-12-2009, 03:14 PM

so i've got a list of names in a column

say:

C6 has a name
C25 has a name
C30 has a name
C32 has a name

and C33 has a $ symbol

what i want a button to do is to grab the 4 names in column C and then place them in a different sheet. when it reaches the "$" symbol, i want it to stop trying to pick up names

(i also want it to start searching from row 4 down to the row with the $)

**solnajeff** · 02-12-2009, 03:25 PM

Hi

Do any of the other cells in the desired range have any values and if so are they numerical or text.

Regards

Jeff

**torontoguy** · 02-12-2009, 03:30 PM

no, the others have no values whatsoever

they are blank

**solnajeff** · 02-12-2009, 03:45 PM

Hi

The following code will find any names within the range specified and transfer them to sheet 2 starting at A1, please amend to whatever location is appropriate.

Please Login or Register  to view this content.

Regards

Jeff

**torontoguy** · 02-12-2009, 03:55 PM

alright, i shall try this out

thanks!

**torontoguy** · 02-12-2009, 04:33 PM

hey

sorry for the double post

i just noticed that if i add more to the list in Sheet 1 and then press the button again
it'll show sheet 2 continue with the repeats

eg.

was:

lee
walker
manda
$

and now changed to:
lee
walker
tiger
manda
$

the Sheet 2 once clicked during both those times would show:

lee
walker
manda
lee
walker
tiger
manda

is there any way i'd be able to reset the write on Sheet 2 to make it start from A1 again