software

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 amp; 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: www.excelforum.com/member.php...oamp;userid=32674
View this thread: www.excelforum.com/showthread...hreadid=524795I'd use the vlookup function to do this.

quot;Royaljellyquot; wrote:

gt;
gt; Hi Folks,
gt;
gt; I'm pretty much an Excel newbie and need some help. I'm trying to
gt; extract some data out of 2 separate spreadsheets, and I need some help
gt; to automate the process. It's actually for a medical office and we're
gt; moving our patients from one clinic to another.
gt;
gt; Each spreadsheet has about 1000 patient names on it, in this format:
gt;
gt; Column A
gt; Last name, First names
gt;
gt; Column B
gt; Patient Tel number
gt;
gt; Sheet 1 has all the names of Dr. T has registered under her name.
gt; Sheet 2 has all the names that Dr. T has ever seen in the last year
gt; (includes patients that are registered under another doctor in the same
gt; clinic).
gt;
gt; Is there a quick way to compare the 2 spreadsheets, so that only the
gt; names that match on Sheet 1 amp; 2 will be saved? The purpose of this is
gt; so that we can call these patients that belong to Dr. T to move to our
gt; new office, and we don't want to call anyone that hasn't been to our
gt; clinic for over 1 year.
gt;
gt; Thanks.
gt;
gt; - Ray
gt;
gt;
gt; --
gt; Royaljelly
gt; ------------------------------------------------------------------------
gt; Royaljelly's Profile: www.excelforum.com/member.php...oamp;userid=32674
gt; View this thread: www.excelforum.com/showthread...hreadid=524795
gt;
gt;