VBA to group rows

**DJ_Rutts** · 10-29-2010, 05:17 AM

Hi People,

I had help with a VBA previously to group rows together based on what drop down was selected. The drop down is column C 'Area' on worksheet 'Completed'. There is a choice of 4 drop downs to select. All rows with the same drop down (Motor Claims/HH Claims/Commercial/General) should be banded together by colour and then put in date order for that group.
I have made some changes to the worksheet since the VBA was added and now it doesn't work. I tried tweaking it to suit the new table lay out but Im unsure of what parts need changing, so it hasn't worked.

Could anybody help please? I have attached the spreadsheet.

Dan

**davesexcel** · 10-29-2010, 07:29 AM

The Code errors right now because column B is empty

**DJ_Rutts** · 11-01-2010, 09:57 AM

Thanks. Column B, F, H, K & L are new additions since the VBA was created. The drop down which would decide the grouping used to be in column B but is now in column C.

I have amended the VBA to look at column C but it is only changing the row up to J. Can you advise how I would include up to column L in the row?

I would also like the groups to be shown in 'implemented' date order (UK) but I am unsure which part of the VBA I need to amend for this.

Lastly, if I select a group drop down from column C (area) such as 'Motor Claims' for example, this will colour and group all these together but remove any colour from all the other groupings. I have no idea why this is and would appreciate any help!

Thanks in advance

Dan