Comparing rows in excel

**ChalkerL** · 11-20-2009, 03:25 PM

Hi, I'm having difficulties comparing rows from two different worksheet.
I have one worksheet that holds person specification, another being the job application database.

And in the this 3rd worksheet - shortlisted worksheet, I'm trying to use a tool to compare rows between those 2 worksheets, and results should only be displayed if the values in entire row for person specification matches the values in job application database.

I'm trying to use macro, and was wondering if there are any easier method.

I tried writing the codes, but how do i compare the values for both worksheets.

Please take a look at my attached to better understand my problem.

Thanks. Any help would be appreciated.

Please Login or Register  to view this content.

**mrice** · 11-20-2009, 03:37 PM

You could get your code to set the value of autofilters on your person sheet to the values in the job specification.

e.g.

Please Login or Register  to view this content.

**ChalkerL** · 11-20-2009, 04:05 PM

Thanks for the reply. What does the line do? Care to explain more =)

Cause i need to do comparison of rows between two worksheets before auto-filtering.

**ChalkerL** · 11-20-2009, 04:27 PM

I'm not really good with VBA. Sorry abt that.

**ChalkerL** · 11-21-2009, 02:05 AM

Hi, i thought of using Vlookup for comparing of rows. Could i sort it based on the dropdown box, say if user were to choose adminstrator, the vlookup will be based on that results, likewise for other job specification.

**mrice** · 11-23-2009, 05:44 PM

Try

Please Login or Register  to view this content.

This should set all the appropriate filters on the database sheet with single or multiple criteria where the criteria are comma separated in the person spec sheet. You will need to be careful that you use exactly the same terms otherwise the subtle variations in spelling will cause the routine to give unexpected results.

Select any cell in the person spec row of choice and run the macro.