VBA macro reconsiliation
This project was successfully completed by deepbluetech for $120 USD in 7 days.Get free quotes for a project like this
Project Budget$120 USD
Completed In7 days
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.
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online