I am working on a roster list and the problem I am coming acroos i
this.

Here's my setup. I have a main page that I use t
access\view\manipulate all information. I have an info page tha
contains all the data I need depending on which situation I'm workin
on.

On the main page I can mark which records I want to view data on.

It searches the info page for the records I have marked

It returns the info I want.

Main Page:

title and Last Name Mark(X)
Mr. Johnson x
Mr. Smith x
Mr. Anderson
FCC Yeti x
ACC Fowler

Info Page:
Laste Name First Name Middle Name Title
.......................


My problem is when running the Macro, I cannot figure out how I can ge
VB to take out the title away from the last name (which I need on th
main page for other items). What I was thinking was

Name = ActiveCell.Offset(0, -1).Value
Sheets("info").Select
Range("A1").Select
Do
ActiveCell.Offset(1, 0).Select
Loop Until ActiveCell.Value = CONCATENATE(RC3, " ", Name)

This way it searches for the name along with the title until it gets
match but I keep on getting "Sub or Function not defined" Any ideas o
how I can go about this? (Note: RC3 is where the title is located at).


Thanks,


J. Vamo

--
vamos
-----------------------------------------------------------------------
vamosj's Profile: http://www.excelforum.com/member.php...nfo&userid=869
View this thread: http://www.excelforum.com/showthread.php?threadid=27348