I have several Business Lines that submit General Ledger and/or DDA
reconciliations monthly to me. Within each individual reconciliation (Excel
Format), there are approx. 0-14,000 items listed. Each Business Line may have
up to 1000 reconciliations.

Is there a way to set up a program, whether a macro, something from one of
the drop down menus, etc that I could use for each individual reconciliation
without having to type or enter helper columns to gather a percentage of
items that would equal (example) 10% 10,000? Each month, the reconciliation
submissions totals of items are always different.

I guess you could say I am looking for a short cut to use for each
individual recon form that would not take up too much time.

Any help would be greatly appreciated. Thank you!