spreadsheet.gif
i need to write a macro that take values from B2:B8
and subtracts the value from the max value in E1:E12 if the value hits zero and some value is remaining then it would go to the next max value
the amount subtracted from each value would need to show up in cell G with the remaining amount from E showing up in H
for instance I'd take credit cards value of 2476.21 and subtract it from soft goods then the remaining from gifts, jewerly then textbooks....until the amount is 0 in column B2 for credit cards.
The macro would go through all values in B2:B8 in that same manner where it subtracts the amounts out of E1:E12.
If anyone could help me figure this out i'd really appreciate it.
Bookmarks