Forum Discussion
A self-updating graph...
So...Now I have a table for the date, I don't appear to be able to sort the spreadsheet based on it?
If I use the drop down tab there are the options to Sort old to new, mew to old etc., but these only do that column...
I used to be able to select the whole spreadsheet and organise it via date.
Each of our piles has a unique number between 001 & 780 and they are not being installed in numeric order.
So now, how can i get the entire spreadsheet to sort, based on the date 'oldest to newest'?
When I select the entire spreadsheet now, the 'sort & filter' tab on the ribbon is greyed out and as I said up there, the tab on the table only sorts that one column....
cheers
N
Nick_W1890Hello Nick, it is very difficult to give you a good tip without knowing your worksheet. Therefore my statement: If you can format the date column, or all your entries as a table, then it works as described. If it doesn't work, then it doesn't work that way. You might want to familiarise yourself with tables in Excel. See here: Table
- Sorry... Logged off for the weekend.
Yeah. That worked. I've not done much with tables before so it's all uncharted territory...
It works a treat now.
Cheers
N