| Home > Forum Home > Analyzing Corporate Financial Data > Circular SUM > circular sum | Share |
Circular sum
Excel Help for Circular Sum in Analyzing Corporate Financial Data
| Forum Topic | Login |
Circular Sum | Rate this: (3/5 from 1 vote) |
 | suppose you already have 4 in A1 type in B1 also 4 righclick sheet tab click VIEWCODE copy paste this code in the window which appears [code] Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Address <> "$A$1" Then GoTo line1 Target = Target.Offset(0, 1) + Target Target.Offset(0, 1) = Target line1: Application.EnableEvents = True End Sub [/code] now change the value in A1 see what you get again change and see post feedback | |
| Posted by [email protected] on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for circular sum in the Excel Business Solutions Directory |