Create a macro in excel 2016 to compare 2 workbooks and highlights differences

Cancelled Posted 5 years ago Paid on delivery
Cancelled Paid on delivery

On excel 2016- I have a macro set up already to compare two files and highlights differences in different ways depending on differences .i would like to have it reviewed and corrected as it is still not 100% behaving as expected.. What is expected is as follows :

1-colour tab in red if it’s worksheet is modified

2-highlight in yellow if an existing row’s values were changed and put in bold the changed values

3- highlight in blue a new added row and put all new values in bold

4-If a row was deleted from the original file then add it in grey to the modified file at the end of the last row in that file.

5-If values deleted from cells , highlight row in yellow as in 2 above AND put back the value in grey in its cell to see it

What needs done in this request:

1- review the macro and make sure it behaves as expected and fix bugs

I am sending the macro file along with the one to be tested .

Excel Visual Basic

Project ID: #17612602

About the project

11 proposals Remote project Active 5 years ago

Awarded to:

Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m More

$140 CAD in 3 days
(220 Reviews)
6.8

11 freelancers are bidding on average $108 for this job

zebracaro

I can do it for you quickly and exactly. Please contact me for saving your time and your money .

$100 CAD in 3 days
(124 Reviews)
7.0
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Ok. Good. Willing to take up your project. Thank you, Regards.

$75 CAD in 1 day
(107 Reviews)
6.3
mail2vimalarora

Hi, Being experienced in working on excel macros extensively, i can help in getting fixes/changes you need as per your mentioned requirement. i assure you of quick and efficient solution and also if there are any mi More

$88 CAD in 3 days
(101 Reviews)
5.8
tanmayshiwan303

Excellent excel automation, delivered macro xlsm to US based clients.

$94 CAD in 2 days
(0 Reviews)
0.0