*0 Sum Variance Macro* Please help

**kennonp** · 06-20-2017, 02:58 PM

Hello,

Is there a way to automate finding all numbers that sum to "0" in a raw data sheet and highlighting them?

i can attach an example file if you need more info..

**Kaper** · 06-21-2017, 04:51 AM

If you want to do it manually, you can use solver for that.
And of course solver could be used/invoked in macro code.
But the useability of solver depends on your data, so yes, attach the example file (it is almost always a good idea).

Also - have a look if you can adopt some of the already published solutions for similar problems, (to show just few):
https://www.excelforum.com/excel-for...ain-value.html
http://www.excelforum.com/excel-prog...ing-macro.html
http://www.excelforum.com/excel-prog...sum-split.html

**kennonp** · 06-21-2017, 08:40 AM

0.PNG

here is a sample file - the highlights are variances under $5 threshold. I want to automate finding the 0 sums.

**kennonp** · 06-21-2017, 08:50 AM

Here is a sample file to look at

**kennonp** · 06-21-2017, 08:52 AM

columns F,G, and H are the reconciling columns in the raw data sheet. don't worry about any other sheets. Thanks gurus!

**Kaper** · 06-22-2017, 06:48 AM

1) The picture you posted is not reflected in worksheet data, so not very helpful :-(
2) As other sheets are not needed - why clutter?

0 Sum Variance Macro Please help

LinkBack

Thread Tools

Rate This Thread

Display