VBA code to split sales report sheet to groups by invoice type to a new worksheet

olali

New Member
Joined
Jun 25, 2013
Messages
6
I have a sales master data (with over 20 columns).
It contains the following:
S/N, Customer, Invoice date, Due date, vessel, producer, fiscal regime, quantity, price, sales value, date paid, amount paid, variance, remark, etc

1.) I need a macro to group this report by invoice type, sum each group, with the column header and group title for each group on same sheet.

2.) Copy 1 or more groups to form a another report on separate sheets

3.) Write the summary (like a pivot table) for some of the column headers. Eg, Fiscal regime, sum by each producer with columns quantity, sales value and receipts

4.) Group 1 or more of the summaries to form another report on separate sheets.

Not to write too much, I am able to provide more clarity when we start.

Thanks for your kind assistance.
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,118,658
Messages
5,573,447
Members
412,529
Latest member
cTatch
Top