R
Royaljelly
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
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