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

In Progress

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: Data Processing, Excel, Visual Basic, Windows Desktop

See more: excel macro group data, macro group data, group data macro, macro group data excel, macro will group data, excel group column macro, excel macro group column, excel macro group, macro group column, excel group column, the one group, code group, group column macro, excel script group data, column group excel macro, group data excel macro, urgent need for excel, pivot table excel, macro, Macro excel, macro + excel, group, excel table, excel pivot, excel pivot table

About the Employer:
( 79 reviews ) metairie, United States

Project ID: #842350

Awarded to:

fedalal2

Hi, I'm guru in Excel automation. Please PM me. Best Regards, Alex

$30 USD in 1 day
(32 Reviews)
5.5

10 freelancers are bidding on average $55 for this job

binaryromel

Ready to start. Thanks.

$50 USD in 0 days
(38 Reviews)
5.0
mohds2

Hello, My bid is for Excel macro. Kind regards.

$50 USD in 1 day
(16 Reviews)
4.6
vipulctyagi

check the details. This software will do everything you need and in a better way.

$200 USD in 2 days
(0 Reviews)
0.0
MarkJoseph4617

I provide great jobs at a very minimal cost.

$30 USD in 3 days
(0 Reviews)
0.0
absrads

Hello, Kindly refer to your PMB. Thanks.

$50 USD in 0 days
(0 Reviews)
0.0
kiranbabar03

I am new here.I will suggest you to try the new loyal,sincere,hardworking person that is me.

$30 USD in 1 day
(0 Reviews)
0.0
datanetsolutions

plz give me a chance

$30 USD in 1 day
(1 Review)
0.0
punshar71

this can be done simply by creating a pivot.. no need to do anything else.

$30 USD in 1 day
(0 Reviews)
0.0
imranjan86

I have four years of work experience in Quick Books,i setup already four companies quick books chart of accounts,one company in Dubai ,UAE,the other are in Bahrain & Pakistan. I am an advance user of Microsoft Office More

$50 USD in 3 days
(0 Reviews)
0.0