Removing Duplicate names from 2 seperate spreadsheets

**Zyphon** · 05-14-2007, 05:42 PM

Hi Guys,

I have this problem, I have two spreadsheets that I use with a list of students.

One spreadsheet has a list of students that have done Tuition courses.

The other spreadsheet has a list of students doing Revision only courses.

What I need is a routine that can check all those students that have studied a tuition course and are currently studying a revision course with us and remove those students from the Revision list, leaving only the students that have only done a revision course and not tuition. Is this possible?

I know this may involve a VB routine or a Macro. Any help offered would be great.

Column A has the student number, Col B has the student name and Col C has the subject they are studying.

Thanks

**jack_in_the box** · 05-15-2007, 08:13 AM

Sounds like you need to make use of the Vlookup tool. I suggest that you merge the 2 workbooks into one, with the s workbooks each in a seperate worksheet. You can then name the worksheet Tutions & Revisions (or whatever you prefer) the use the Vlookup tool to find the information that appears in both worksheets.
I hope that helps

**Zyphon** · 05-15-2007, 09:30 AM

@jack_in_the box

Thanks for your help, this sound good.

Is there a way to automatically delete all the rows I don't need?

**jack_in_the box** · 05-15-2007, 09:50 AM

You can use the Vlookup to insert a result from another column into a new column (if I remember collect). Then all you need to do is sort the table by that column, the blank cells will the be either at the top or bottom & visa versa for the returned results. Have that which you want to delete at the bottom of the column so you can easily select them all & delete them.

There might be a way that the Vlookup can delete them, but I'm not 100% sure - haven't used it a while

If you like you can attach the spreadsheet for me & i'll take a look for you.

**Zyphon** · 05-15-2007, 02:28 PM

Thanks for your help I shall make a sample spreadsheet for you to look at.

I really appreciate your help.

**Zyphon** · 05-17-2007, 04:02 PM

Hi Sorry for the delay in responding.

Attached is a test sheet to show what I want.

As you can see from the two tabs some students attended both Tuition and Revison.

I need to find only the students who are doing a revision course from the Revision tab and remove those students who did both Tuition and Revision.

How can I achieve this? Does this need to be a vba routine?

Thanks again for your help.