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

This project was successfully completed by fedalal2 for $30 USD in a day.

Get free quotes for a project like this
Project Budget
Completed In
1 day
Total Bids
Project Description


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.


Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online