Thanks for your many videos of help. I have a situation where I need to sort a given number of rows and columns within a table leaving the header row intact.
By way of example. I have row 2 as a header, columns A & B as ‘headers’ and I want to sort columns E through J and rows 5 through 100 leaving everything else intact. I can’t seem to find the answer to this. Can you help?
So columns A & B are suppliers. Column’s E is a date column and F through K are same suppliers as Column A & B. However, Columns E ~ K are daily expenses listed with a total of each column in row 100 while Columns A & B is just a snap shot showing totals for each supplier.
Sometimes an expense is presented out of date sequence and instead of making space somewhere in the spread sheet to fit it in, it is easier to add it on the end and then do a sort to get it in the correct sequence.