O
ozonedman
I have a customer sheet with 2-3 thousand rows, each with 24 columns.
At any time, a row may be split(new row) and the values in A thru D
(names) and from column K (due) copy/pasted to the new row, and a text
value added to column E to note it. I've managed to do that with a
macro, probably with many more lines than necessary.
I now need to split that dollar value in column K into THREE new rows
when I copy it (payments), what code do I add to get three equal
amounts in those three new rows? Is there a quicker way to do this
without the 40 lines of code I have now?
At any time, a row may be split(new row) and the values in A thru D
(names) and from column K (due) copy/pasted to the new row, and a text
value added to column E to note it. I've managed to do that with a
macro, probably with many more lines than necessary.
I now need to split that dollar value in column K into THREE new rows
when I copy it (payments), what code do I add to get three equal
amounts in those three new rows? Is there a quicker way to do this
without the 40 lines of code I have now?