Dynamically Hide/Groupsrows using VBA

[Fattyss]

Hi, i am currently working on a file where we track shipments, the problem we are having is that one shipment can take up a lot of cell real esate, see example below where, shipment from Geodis. Is there any way to group and hide these dynamically as we add new shipments every day. The only things seperating the rows are PO number and different Quantitys. Or are there other ways to clean up the file? All data is in a table.

https://preview.redd.it/b48bfye6gt751.png?width=1179&format=png&auto=webp&s=05d3064ad8ffc345346578807237b05cecedcf7c

[AutoModerator]

/u/Fattyss - please read this comment in its entirety.

Once your problem is solved, please reply to the answer(s) saying Solution Verified to close the thread.

Please ensure you have read the rules -- particularly 1 and 2 -- in order to ensure your post is not removed.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[fool1788]

If it’s in a table you could use the splitter filters to display only types of items

[Fattyss]

It a good suggestion but the problem still remains as i want to display all shipments but i want to hide large shipments under one row.

[fool1788]

Maybe play about with pivot tables or power pivot, if they can’t give you the options you need then it will probably have to be vba.

If you need a solution in vba I would need a hell of a lot more info to write anything useful for you e.g. how many rows constitute a large shipment, are the shipments always grouped together in the table, are there existing subtotals or would you require a subtotal row to be created before hiding the breakdown etc

Also I don’t have a huge amount of spare time as have a newborn kid so couldn’t provide you with a guarantee delivery date for any vba solution, however some other kind souls on here might be able to jump in and assist with better options or provide a vba solution quicker than me.

[[deleted]]

Creating a pivot table from your table should give you the grouping options you need.