You could create a pivot table which would give you that output in another
location.

Data=Pivot Table Report and Chart

--
Regards,
Tom Ogilvy


"AyeJay" wrote:

I'm not sure if Concetating is the exact way to go about this but what
I'm trying to do is take:

Drawing Amount | Drawing Number
--------------------------------------------------
4 506888
6 506889
2 506888
3 506889


And make it look like:


Drawing Amount | Drawing Number
--------------------------------------------------
6 506888
9 506889


Through a button-push on VBA.
Anyone have any ideas on how to accomplish this?