Inserting a blank row after filter

[chrisellis250]

Hi all,

I have a spreadsheet that is filtered based on a criteria match.
Is there a way to insert a blank row after each filter, so to break up the filtered sections of the workbook into groups?

Any ideas much appreciated.

Regards,

Chris

[JBeaucaire]

That's going to get Chaotic.

I recommend you dive into PIVOT TABLES using your current data as the data source. Once you've connected a Pivot Table to a data source, you can arrange the Pivot to organize your data based on any grouping you can think of. The end result is out of the box organized and summarized by the very filtering groups you're applying.

If you've never worked with Pivot Tables, you're in for a treat. Our forum and the web is full of easy to follow examples and tutorials, you're going to love it, I promise. Push past the unfamiliar to get your first pivot or two going, you'll fall in love with them pretty quickly.

That's my best advice on this request.

[PCI]

In complement to JBeaucaire, if you had the chance to attach an Excel sample, it could be possible to help you for a Pivot Table.