Hi Folks,

I'm pretty much an Excel newbie and need some help. I'm trying to
extract some data out of 2 separate spreadsheets, and I need some help
to automate the process. It's actually for a medical office and we're
moving our patients from one clinic to another.

Each spreadsheet has about 1000 patient names on it, in this format:

Column A
Last name, First names

Column B
Patient Tel number

Sheet 1 has all the names of Dr. T has registered under her name.
Sheet 2 has all the names that Dr. T has ever seen in the last year
(includes patients that are registered under another doctor in the same
clinic).

Is there a quick way to compare the 2 spreadsheets, so that only the
names that match on Sheet 1 & 2 will be saved? The purpose of this is
so that we can call these patients that belong to Dr. T to move to our
new office, and we don't want to call anyone that hasn't been to our
clinic for over 1 year.

Thanks.

- Ray


--
Royaljelly
------------------------------------------------------------------------
Royaljelly's Profile: http://www.excelforum.com/member.php...o&userid=32674
View this thread: http://www.excelforum.com/showthread...hreadid=524795

I'd use the vlookup function to do this.

"Royaljelly" wrote:


Hi Folks,

I'm pretty much an Excel newbie and need some help. I'm trying to
extract some data out of 2 separate spreadsheets, and I need some help
to automate the process. It's actually for a medical office and we're
moving our patients from one clinic to another.

Each spreadsheet has about 1000 patient names on it, in this format:

Column A
Last name, First names

Column B
Patient Tel number

Sheet 1 has all the names of Dr. T has registered under her name.
Sheet 2 has all the names that Dr. T has ever seen in the last year
(includes patients that are registered under another doctor in the same
clinic).

Is there a quick way to compare the 2 spreadsheets, so that only the
names that match on Sheet 1 & 2 will be saved? The purpose of this is
so that we can call these patients that belong to Dr. T to move to our
new office, and we don't want to call anyone that hasn't been to our
clinic for over 1 year.

Thanks.

- Ray


--
Royaljelly
------------------------------------------------------------------------
Royaljelly's Profile: http://www.excelforum.com/member.php...o&userid=32674
View this thread: http://www.excelforum.com/showthread...hreadid=524795