Macro help

Viking08

Board Regular
Joined
Feb 9, 2004
Messages
120
Is there a macro that can help me with this problem?

I am balancing some numbers in a spreadsheet, 2,499 of them and I am out of balance by 880,000 between 2 catagories. Is there a macro that can search through the balances in column "C" that can search for two numbers that total 880,000?

Thanks.
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Viking08

Board Regular
Joined
Feb 9, 2004
Messages
120
I found them before when there were fewer numbers in the database. Apparently, it has never been corrected.

If there is a way to use more than 2 numbers in the macro that totals 880,000 I can always use that in the future.

Thanks.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,020
Messages
5,569,664
Members
412,286
Latest member
kychemist00
Top