VBA Macro to format credits and debits.

I wanted to thank you all in advance for your assistance with my project. I’m afraid that I am not very good with formatting so you might find my example odd as the layout is exactly how it appears in my “real” application making it much easier for me to apply once a solution is created.

I need a VBA Macro that will separate the buys and sells on Sheet1 (we don’t know how long this list will be) and place them nicely on the print out page including the summary info that you see (total # of transactions and total). You will see that the Debits side data is dropped in Col G, H, and K which is UNLIKE the Credits but that is because on the page above it (note this starts on like 53) there is more formatting so it needs to be dropped like that.

There SHOULD never be any more than 29 of either Credits or Debits so we don’t need to worry about going over.

Thank you again.

Yes, I agree PT is much more easier to maintain. I have included a code, but I am not sure if you could tweak it yourself should the layout changes.

Guys your all amazing! Thank you so much for this.

YEP! Thank you!