Grouping rows by criteria excel vba

What I need;


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.

Thank you.

In addition to last comment from Pepe, an Excel sample file, showing what is the data and the expected result(S) is always more than welcome.

Originally Posted by PCI

In addition to last comment from Pepe, an Excel sample file, showing what is the data and the expected result(S) is always more than welcome.

Please find attached a sample with a code I have attempted...

Sheet1 contains master data, sheet2 contains the filtered data copied from sheet1.

Please Login or Register  to view this content.

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

I made a table of the data.

After that a filter on column A and select
empty cells, totals, restaurants.

After that I deleted the filtered rows.

After that I selected al in the filter.

See the attached file.

crossposted: https://chandoo.org/forum/threads/vb...5/#post-263367

https://www.mrexcel.com/board/thread...l-vba.1132269/

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

Then please post the solutions you found on the other forum, on behave of all forummembers.

You did also not replied to my solution.

in #10 you post No solutions from any source yet...

and my post #6?

Sorry once again.

Each time I play with code, keep getting an error and macro doesn't run. I'm not VBA pro but keep trying to play with code until I discover I have no hair left.

I thought this thread would help but not quite but the nature of this query is similar hence didn't want to start a new thread per se.

Per attached file, I have the below code working for Grouping but it is based on Column A having a "1".

I need help to modify the code on just one change such that it is Grouping based on criteria "Total" in Column A and not the number 1.

Much appreciated as always for any assistance.
Nick

Please Login or Register  to view this content.

@RKK1699BGC

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)


Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

If you are satisfied with the solution, please mark the question solved.