VBA for colouring and banding groups together

[DJ_Rutts]

Hi guys,

I am currently building a dashboard showing outstanding and completed jobs that come through our department. I had help with a VBA previously to group and colour different types of jobs on the 'outstanding' work sheet and am hoping to get some further help.

I am looking to do the same for the 'completed' work sheet. The 4 different categories in column B are: Motor Claims, HH Claims, Commercial and General. I would like these to be sorted into colour groups based on these categories and then listed by the implemented date, the same as with the 'oustanding' job work sheet. I have tried using the same VBA but editing the details but could not get it to work.

I also wanted to know if it was possible to add an 'implemented' status to the 'outstanding' table and when this is selected, the details transfer to the 'completed' table, highlighted in someway so it can easily be spotted and the other details in the row can be filled in? Maybe this is asking too much?!!

I have attached the spreadsheet.

Thanks in advance

Dan

[DJ_Rutts]

Sorry ! Didn't put the attachment on the last post!

Dan

[DJ_Rutts]

*** solved ***

[teylyn]

DJ_Rutts,

could you please pick up on the suggestion I posted in your previous thread about how to mark a thread solved? Thanks for putting in the "solved" in a post, but please use the proper way to mark the thread solved in the list view.

thanks.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save