1. Yes but..when you open the workbook it will come up with the secutiy waning..( eg:if xl is setup at medium it willask if you if you want to enable macros.
To insert the code to run automatically insert it in the sheets code area.
press ALT +F11 and then click on eg: sheet1 and paste the code in there.
2. When it the target area in the macro is set eg:" I1:I112" then this macro only runs when a user changes the I1:I112 cells manually...Not by the fact that a formula changed the value.
The formulas in column "I: will not be affected by the macro so they can remain.
3.Put at the end of the macro
Bookmarks