Automatic Sorting after adding a new row entry

[Aarron2]

Hi,

I am in the process of creating a task manager and would like the sheet to sort in a particular order. I can get this working with the Sort function in Excel but this only sorts what is currently there but when I add a new row, this is not sorted and I need to click the Sort button again to refresh the sort.

The order I'd like for it to appear is:

Red Cells (Tasks not started)
Orange Cells (Ongoing tasks)
Green Cells (Completed)
And finally... a newest to oldest newest for the Green cells

This is how I currently have it set:
image001.png

Could someone assist in pointing me in the direction or what Macros or VBA I could use to achieve this.

Thanks in advance, greatly appreciated.

Aarron

[Logit]

.
This macro (paste in the Sheet module) will auto sort Col F when something new is added. You can edit the column to suit.

Please Login or Register  to view this content.

[Logit]

.
Also for the conditional formatting review this resource :

https://stackoverflow.com/questions/...t-row/16831756


This response is located about half-way down the page :



I agree with what has been posted previously; copy and paste values (or paste formulas) will totally work to not split up the conditional formatting.

I'm a little lazy for that. And I don't want those who use my spreadsheets to have to do that. I'm also not confident that they will remember to do copy and paste values.

I don't know if this solution will work for your needs, but I resorted to deleting all conditional formatting and reapplying the correct conditional formatting every time the workbook is opened.

Because this macro runs every time the workbook is opened, the user does not need to change the way they copy and paste. They don't need to know that the macro is even there. They don't need to manually run the macro; it is automatic. I feel this creates a better user experience.

Please keep in mind that this code needs to be copied and pasted into the "This Workbook" module; not a regular module.

Please Login or Register  to view this content.

answered Sep 14 '18 at 16:58 by : irockyoursocks

[Aarron2]

Many thanks for this, I dont suppose you have a sheet to share showing this in action as Im not totally confident on what I amend to sort it the way I'd like, sorry newbie to all this but appreciate your help.

[Logit]

Which column are you sorting on ?

[Aarron2]

I have attached the sheet. Im mostly just wanting the colours sorting so red first.. then orange and then green. Its column H for the colours and then as a final sort after the colours the rest of the greens to be sorted by newest first (this not important though) thank you for you help

Which column are you sorting on ?

[Logit]

.
Using Column H (that has the colors) and running the Macro Recorder .... this is the macro it created :

Please Login or Register  to view this content.

The range has been set for H5 to H100. You can edit that for as many rows as desired.

[Aarron2]

Thank you for this

.
Using Column H (that has the colors) and running the Macro Recorder .... this is the macro it created :

Please Login or Register  to view this content.

The range has been set for H5 to H100. You can edit that for as many rows as desired.

[Logit]

.
You are welcome.