Macro to group and un group rows?

**gjjh25** · 12-12-2012, 05:14 AM

I do a lot of construction pricing work which tends to have a lot of repetitive item in the list to be priced.

I was wondering is there a way to temporarily group the items together so it easy to enter the rate and then restore the list to how it should be.

So in the enclosed example I have highlighted the dispose on site, could I for example select this cell and then have a macro to bring all the same rows together so I can enter the price and then put the rows back in the correct place. Then move on to another cell that has repeated items and do the same?

**watersev** · 12-12-2012, 06:03 AM

hi gjjh25, I hope I get your idea correct, select non-empty cell in B column and press "ALT+UP arrow", after changes have been made press "ALT+DOWN arrow"

**gjjh25** · 12-12-2012, 06:25 AM

Watersev,

That is exactly what I was looking for thank you.

One last question how do I get it to work on any new excel document I receive please?

**watersev** · 12-12-2012, 06:43 AM

Among the simplest options:
1. Move sheets from different workbook to this one and use it as you would like, move back
2. The feature uses two main codes: AFon and AFoff. You can copy them to a Personal macro book (if it does not exist you can create it. The other two codes that assign actions to key combinations are sitting in ALT+F11 - ThisWorkbook. You will need to transfer them into Personal macro book into Thisworkbook and save it.

**gjjh25** · 12-12-2012, 07:03 AM

Thank you I have Created a Blank master for this sheet which I think is easiest.

**watersev** · 03-06-2013, 09:41 AM

hi Graham, option to make it, for example, 4 lower rows visible after grouping. The key combinations are the same: [ALT+UP Arrow] to group and [ALT+DOWN arrow] to ungroup. After pressing [ALT+UP Arrow] please note outline markers on the left: 1 and 2. If you press 2 you will see those 4 rows under each grouped header. Please test it if it suits your needs.