I have a table that varies by size
but it starts from range A2:F12, sometimes A2:F11, A2:F10, A2:F24 etc
It is not contant, can i have a macro that can select the whole table by default and then sort it by col b in sheet1, from highest to lowest???
If I just record normal macro...