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

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Watch MrExcel Video

Forum statistics

Threads
1,119,241
Messages
5,576,912
Members
412,753
Latest member
Coach_Olson
Top