I need to make a formula that inputs data from one column into another set of columns. Basically column (A) has dollar value, column (B) has code (A1-A7) manual input. the code (A1-A7) determines which column data from column A cell 1 goes into (column C-I), and so on down the column
Column C-I have dollar amount set, and the values from column A get separated into columns C-I and get subtracted from the respective columns set dollar amount. Essentially an overpowered check book for construction allowances.
