Closed

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

This project was awarded to fedalal2 for $30 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
N/A
Total Bids
10
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,

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