Hello all, I'm hoping you will have time to assist me understanding how to best tackle this comparison list shown at the following link.
https://docs.google.com/leaf?id=0B7Wrlvw2fV31ODliYzkwMWYtMzRhMi00OGU4LTliZTQtMzUxZDQ5OWQ2OGUy&hl=en&authkey=CJutsIkC I'm given a range similar to ("A1:B5") and need it to end up like range ("D1:E6"). Basically I have two list and need to sort out and add in blank cells to anything that does not match from either side. Thank you in advance for any bits of VBA or places to start my seach. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel