Budget Template.021.xls | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |||
48 | Company 1 - first $25,000 | [insert company] | 25,000 | - | - | - | - | - | - | 25,000 | ||||||
49 | Company 1 - over $25,000 | 10,000 | - | - | - | - | - | - | 10,000 | |||||||
Details |
OK For example, using the above set of cells. When the user clicks in columns J:P, in either row 48 or J49, a text box becomes visible with current focus, in which the user can enter a number. When the text box loses focus, I need to put proper values into rows 48 and 49.
I want all values less than 25K put into row 48, and once the sum of J48:P48 exceeds 25K, all subsequent values are placed into Row 49. For the special case where 25K is exceeded in a column, any value<=25K goes into row 48, and any remainder goes into row 49, and then all subsequent values go into row 49.
Any suggestions? I'm trying to abstract a function, as there are multiple rows that behave this way (same display requirements).
Thanks in advance,
Nicholas