Need help copying data from one column to specific columns

M

mark

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Copying specific rows to another sheet 2
Need Help with a VBA subroutine 0
Need a little help with a custom function 1
Remove duplicates in one column within a range of dates in another column 6
Need VBA solution to find 1st and 2nd occurrences of non- zero, thenreturn column header value 7
need macro to filter data from multiple sheets in a worksheet 5
Unable to set the desired column width for a table with merged cells 0

Top