Hello,

I'm not a programmer, and my knowledge of Visual Basic is basically nothing. Still, I'm not completely incompetent with Excel. I could use some help if anyone is willing.

Attached is a sample workbook that shows a pretty close situation of with what I'm dealing. On sheet 1 there is data, which in real life, some will be static and some will be dynamic. On sheet 2, there is a table where only one row will be dynamic, and will be pulled off of sheet 1.

The goal is to make each column on the table from sheet 2 to sort in descending order, automatically, and as the dynamic data changes, while keeping it's color code. I think one of the issues is that when the dynamic data feeding into the table changes, it simply changes the data across the row, rather than finding the new and correct location - since the data had been previously sorted. It all gets complicated to write out.

Essentially, everytime this spreadsheet is used, the data will change. The other issue is that I need to format the table to create some white space between columns and rows so that it's easier to read. So far I've been doing this manually and it's driving me crazy. There's got to be a way to do all of this, right?! Any help would be greatly appreciated.