Hey everyone,

I have data in the following columns on a worksheet that I need to get
into seperate columns based on the value in column A (dept).

DEPT DEPARTMENT NAME INV DATE INVOICE $$$
6015 PATIENT CARE UNIT 1-5 4/16/2007 98.69
6015 PATIENT CARE UNIT 1-5 4/16/2007 137.56
6028 4-2 / 5-2 ACCESS UNIT 4/16/2007 1.33
6028 4-2 / 5-2 ACCESS UNIT 4/17/2007 1.33
6028 4-2 / 5-2 ACCESS UNIT 4/18/2007 -1.33
6028 4-2 / 5-2 ACCESS UNIT 4/20/2007 12.45

I have modified other macros to get data to copy to a different sheet
each time the dept changes, but I need to get this one to copy to the
same sheet, but different column when the dept changes

all 6015's in column A (98.69 in A2, 137.56 in A3 etc)
all 6028's in column B

Any / all suggestions welcome