Looking to create a particular functionality in Excel but don't know how to proceed in this regard. Essentially, I want to create an account automator wherein there are 3 columns, A, B, C. Column A is for Debits, B for Credits, and C for Total. The initial row for columns A and B shall be empty while column C would have a value. In subsequent rows value in Column A or B shall be added or subtracted from the value in one row above in Column C and any direct change made to the value in Column C should reflect all the remaining values below in the same column, be it any increment or decrement.
How should I go about doing this? Macros or VBA scripting and in either case, where to look for tutorials/learning material?
How should I go about doing this? Macros or VBA scripting and in either case, where to look for tutorials/learning material?