Urgent!!!!! Need Excel Macro to group data by column ...

IN PROGRESS
Bids
10
Avg Bid (USD)
$55
Project Budget (USD)
$30 - $250

Project Description:
Hello,

I need a script to do 4 things:

a) separate one worksheet of data into multiple worksheets based on account number
b) on the individual worksheets group by a specific column

For example if i have:

Item Qty Length
A 1 100
A 1 100
B 2 200

I would like the macro to replace that by


Item Qty Length
A 2 100
B 2 200

c) create a pivot table to summarize information after data has been grouped

d) Add a customer header (account number) to each spreadsheet

I have partial code for a and c

I need this done very urgently. (within the next 3 to 5 hours at the very most)

This could be done in one macro or as a series of macros.

I will give more information once i receive some answers.

Thanks,

Skills required:
Data Processing, Excel, Visual Basic, Windows Desktop
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 1 days
$ 50
in 0 days
$ 50
in 1 days
Hire vipulctyagi
$ 200
in 2 days
Hire MarkJoseph4617
$ 30
in 3 days
Hire absrads
$ 50
in 0 days
Hire imranjan86
$ 50
in 3 days
Hire kiranbabar03
$ 30
in 1 days
Hire datanetsolutions
$ 30
in 1 days
Hire punshar71
$ 30
in 1 days