Hey
Please can someone help!
I have some data based on whether a check box is checked or not. (See attached screenshots).
If it is checked at level 3 it enters into a table that is coloured by the difficulty of the task, if it isn't checked it doesn't feed through/show and leaves as a blank cell.
I then need a table which auto updates when refreshed (so I thought Pivot table) but the pivot table won't allow me to sort by data source order or by colour, is there any other way for me to do it so that the data shows in the correct order?
Many thanks in advance
Kate
Bookmarks