I have to make small list out of a large data set that has new values added to it weekly. The macros are to delete the unnecessary data and format whats left depending on the list requirements.

I have to order and sort several workbooks of different column lengths and row amounts. I would like the script to be dynamic in the selection. The starting point will always be the same C1. The script is below and I have included “Selection” and “xlToRight” in the ranges. However, that does not work. I know nothing of VBA and am learning on the fly. Edit: I would like to sort on row 2 so C2 I believe.

I’m trying to get VBA to auto sort a column in a Table in Excel when the formula result in the cells in the same column are changed/updated. However, the auto sort code shown below is not triggering unless I manually enter a value into the cell.