Scenario: I have hundreds of tables that stretch from row 1 to row 1452. The tables are an export from another program that display percentages and totals. The total is always 100% but its not really "100%" because when rounding is taken into account, they actually total 101% or 99%. Since it is exported from another program, the 100% is just a value and not a formula. Exporting with the rounding in effect is not an option.

Question: Is there some way, maybe through VBA or a macro, that I could have Excel find every 100% and insert an autosum formula for the values above it? I tried the FIND/REPLACE to search for 100% and replace it with ALT+= which is the shortcut key for Autosum, but it wouldn't take it.

Any help is greatly appreciated!

Open in new window

If it is not column A, change the column reference in Range("A:A") on line#3.