Copy cells from one sheet to another

Originally Posted by StephenR

I've got some pretty much off the shelf code which could do that. Are the last 6 columns are based on S and U?

Yes they are, that was the other problem i found there's 6 category of aging.

0-30
31-60
61-90
90-120
121-360
>360

i have that category shown on the column U and the amount on column S, i want to have those cells shown horizontally instead of vertically. like on the report sheets. is that possible?