Completed

Excel Macro Help

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

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
25
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:

A****************************B**************C***

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

A****************************B**************C***

Bryant*******************ELT12(3)*******36KLM

Handcock***************E0042(6)******334(Z)8

Lancy*******************1XFTXS********222(5)6

Smith*******************126ZLT*********454S5

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

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