MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Comparing Two Worksheets


Posted by Cindy on February 26, 2001 2:54 PM

In simple terms please...Worksheet 1 is student id# and name, Worksheet 2 is all student bio/demo info including id#. I need to compare the two, and pull bio/demo info for all students on worksheet 1 from worksheet 2. Thank you!


Posted by David Hawley on February 26, 2001 5:00 PM


Hi Cindy

Rather than reinvent the wheel here, take a look at this utility.

http://www.rb-ad.dircon.co.uk/rob/excelvba/utils/index.htm


Might just be exactly what you are after.


Dave


OzGrid Business Applications

Posted by Faster on February 26, 2001 5:10 PM

Use the function wizard to walk you through: VLOOKUP