Forum

Thanks Catalin I have now updated with an additional week of data and the script now reports an error of 'subscript out of range' As far as I k...

Hi Catalin your response is very useful, thank you! The challenge I have is that although I can follow the gist of the response, I am unable to com...

Thanks Mynda I moved the two row label columns and unfortunately it did not make any difference - the column will not sort. I have posted a reques...

Hi Mynda Unfortunately using the tabular format and having the item_num and item_name showing in the same row, the sort by dates does not work. ...

thanks John That certainly helped. Still struggling to apply it to the full Pivot Table without copying and pasting the conditional formatting p...