Completed

VBA macro reconsiliation

This project was successfully completed by deepbluetech for $120 USD in 7 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$120 USD
Completed In
7 days
Total Bids
1
Project Description

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




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