Hi Excel Gurus,
This is my first post on a forum so I hope to provide enough info to get some assistance. I have a large table (A1:FL3259) and am trying to figure out how to automatically sort a portion of the table (Column Y:Column FL) when someone clicks on a cell in a given row. For example when a user clicks on cell B3, the table Y1:FL3259 would sort the columns (Y-FL) in descending order left to right based on the table values in Row 3. The user then clicks on B4 and the entire table autosorts again based on the table values in Row 4 etc. There are many blank values in the cells depending on the specific row, but I think those blanks should go to the very right when the sort occurs. I would like the click on a cell to initiate the code as opposed to running the macro each time so it will be relatively invisible for the non-excel savvy user. Any help would be appreciated.
Thanks,
Kyle
This is my first post on a forum so I hope to provide enough info to get some assistance. I have a large table (A1:FL3259) and am trying to figure out how to automatically sort a portion of the table (Column Y:Column FL) when someone clicks on a cell in a given row. For example when a user clicks on cell B3, the table Y1:FL3259 would sort the columns (Y-FL) in descending order left to right based on the table values in Row 3. The user then clicks on B4 and the entire table autosorts again based on the table values in Row 4 etc. There are many blank values in the cells depending on the specific row, but I think those blanks should go to the very right when the sort occurs. I would like the click on a cell to initiate the code as opposed to running the macro each time so it will be relatively invisible for the non-excel savvy user. Any help would be appreciated.
Thanks,
Kyle