Excel Macro Help

This project was successfully completed by danielgpratidya for $33 USD in a day.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
Project Description

I need somebody that will write a macro, that will look through 2 different sheets in excel, and find if there are differences between data. The data in the 2 sheets might not be aligned perfectly, so it will have to look through that.

Sheet 1 will contain:


Bryant, Alan***********ELT12(4)*******1FN236KLM

Doe, Jane************124AHB*********1DNG90236

Handcock, Joe*******E0042(7)********FNG2334(7)8

Lancy, Jason*********1XFTXS*********RGT3222(S)6

Smith, John***********126ZLT*********MGT2454S5

Sheet 2 will contain






What I am looking for is that the data in "( )" should be bolded since they are not the same, and possibly highlight the cell

*note that colum C has the same last digits, but does not contain all of them

*note that sheet 2 only contains Last Names

*note that sometimes the person might be missing completely from the Sheet

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online