Registered: Feb 2010 Posts: 39935 - Threads: 1064 Location: In a wide open space
2016
Winner Thread Honourable Mention Member
Quote:
Matt wrote on 09-08-2017 04:14 PM
You can use copy/paste-transpose to save the data in columns, sort and copy/paste-transpose back.
Tried that last week, it pastes across zillions of columns.
"Do you believe in the devil? You know, a supreme evil being dedicated to the temptation, corruption, and destruction of man?"
"I'm not sure that man needs the help." (Calvin & Hobbes)
Registered: Oct 2010 Posts: 33316 - Threads: 426 Location: london
Today is my last day on his project and it has been a long time coming, our carpets are being laid and curtain rails are going up, by monday the house will be finished so the two biggest demands on my time (apart from the cats) are going to be done with and not before time
Just need to get through today!
And those who were seen dancing were thought to be insane by those that could not hear the music -Nietzsche
Registered: Feb 2010 Posts: 39935 - Threads: 1064 Location: In a wide open space
2016
Winner Thread Honourable Mention Member
Quote:
Matt wrote on 09-08-2017 04:20 PM
You'd need to paste in a different location, probably a temporary sheet.
Are you just sorting one row, or do you need a whole area?
Whole area.
"Do you believe in the devil? You know, a supreme evil being dedicated to the temptation, corruption, and destruction of man?"
"I'm not sure that man needs the help." (Calvin & Hobbes)
Registered: Feb 2010 Posts: 39935 - Threads: 1064 Location: In a wide open space
2016
Winner Thread Honourable Mention Member
My housemate has just finished his 32nd and final session of radiotherapy and is now allowed to have a cup of coffee. He is a fucking fiend about coffee and this has actually been the hardest part for him.
"Do you believe in the devil? You know, a supreme evil being dedicated to the temptation, corruption, and destruction of man?"
"I'm not sure that man needs the help." (Calvin & Hobbes)
Registered: Oct 2002 Posts: 15055 - Threads: 202 Location: Glesgae
My kids. There was a frog in our front garden today and I was rushing to get them to the childminder so I could go to to work. They refused to get into the car until we caught the frog and released it down in the woods. They were worried next doors cat would get it. I was late for work but I can deal with it knowing they're becoming amazing wee people.