Help, Need Macro to reverse accruals in template

[garciab]

Hello,

I would like a Macro that will look for "A" next to a journal entry and copy the items to a new worksheet within the same workbook and transpose the account numbers & Item descriptions vertically.Any help would be greatly appreciated! Thank you!

This is how the template looks:


[TABLE="width: 500"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Account Number[/TD]
[TD]Debit Amount[/TD]
[TD]Credit Amount[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Revenue[/TD]
[TD]0286678050[/TD]
[TD]1000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A/R[/TD]
[TD]0286671011[/TD]
[TD][/TD]
[TD]1000[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]