Deleting / collating data

Hello Hugo,

Thank you for your reply and attached file.

As always there are usually many ways to resolve issues in Excel. Your issue will require a Macro or some VBA coding to perform the necessary actions you need.

I can do what you want using sub-totals then copying and pasting the results into a new sheet with one or two modifications. All in all this method doesn't take too long and can be made quicker if you create a few macros to perform these actions very quickly. If you use macros you probably will have to modify the code a bit so that whenever you wish to run it on fresh data... it will work!

I have attached your file with 2 sheets and some text boxes showing you how to perform these actions.

Give it a try!

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer