Right now the macro will find the high value in column E and subtract it with a value in Column B2-B7 until each cell from B2-B7 reaches 0. I wanted to paste these subtractions into Column G. I also wanted to paste the categories it came from so I could use them for the 2nd part of my project.
I have tired numerous different things but can't get anything to seem to record each subtraction in column G. I was going to paste the category for each subtraction also in columns H and I.
So for instance a credit card subtracting from textbooks would show the amount in G that was subtracted then in H say credit card and I would say textbooks.
Any help would be appreciated.
Thanks
Bookmarks