In Progress

VBA macro reconsiliation

I have a spreadsheet matrix that is 128 by 128.

The matrix cells are linked to 128 worksheets within the workbook.

On the matrix worksheet, we would like to compare 2 cells. If they are equal, then no action is required. If they are not equal, then we need to use conditional formatting to highlight both cells.

We can not use the copy function within Excel. because we are comparing vertical column cells to horizontal rows cells. So it would require me to update all 16,000+ cells.

The macro needs to allow us to go down each column and then compare it to a cell that goes across a row.

Example: Compare (C2 & D1), (C3 & E1), C4 & F1). That process needs to occur for all the cells within the 128 by 128 matrix.

What would you estimate your costs and completion date.

Thank you.

Kim Rhodaback

Skills: Excel

See more: what is vba, me vba, vba excel macro, vba compare, macro vba, f1, Excel VBA Macro, Excel Macro VBA, compare spreadsheet, c3, vba excel copy, vba update excel, excel macro row, vba amp, compare rows excel, excel compare update, excel copy vba macro, vba matrix, vba function, excel column update, macro vba cell, macro spreadsheet, excel vba spreadsheet, compare worksheets vba, use excel function vba

About the Employer:
( 3 reviews ) Northville, United States

Project ID: #4764795

Awarded to:


Hired by the Employer

$120 USD in 7 days
(62 Reviews)