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,
