Microsoft FUCKING excel.
Software for brain-dead accountants written by numbers.
You'd think there would be an easy way of copying all the contents of one worksheet into another, at the end of the data, so oncatenating them together.
Just 2 lists of data in the same format. Similar data for different academic terms.
I just want to select all the date from the first sheet and then paste it all in to the second sheet starting at the first empty row.
Well there probably is, but the fucking stupid slow patronising "Your problem is that you aren't doing it the MicroSnot Way" so-called "help" helplessness reinforcer fucking useless not-helpful-at-all it-isn't-our-problem-mate help screen-out-your-brains-before-you-come-here BROKEN windows help thingy doesn't tell you what it is.
All it tells you to do is select the cells you want to copy, then select EXACTLY THE SAME SIZE AND SHAPE of cells in the place you want to copy them to.
When I have 47413 rows of cells? To be pasted in following row something like 16312? My hand started to give way to pain before I could scroll down that far.
This is meant to be easy and you have to bloody well be able to do mental arithmetic to work out how many rows to page down.
There will be a way to do it. There is probably a way to do almost everything. Micro$hit Snotffice takes up about 400 megabytes on my disk. It can't ALL be wasted on the "Seven Habits of Highly Conforming Corporate Clones" or whatever EST-cult brainwashing drivel they have shipped with this release. Whichever one it is.
Why do they make it SO FUCKING DIFFICULT?
Why do they have that unhelp notsystem that is so much harder to navigate than the one they had 10 years ago? It goes on and on and on about stuff that is just USELESS as if it was HARD to use a spreadsheet and it has NO PROPER INDEX.
At least they got rid of the fucking arselicking willywaving paperclip. If I want to stroke a muppet I'll go to Redmond and bribe them with free non-diet Coke. They obviously suffer from caffeine deficiency, no-one who was awake could write this load of cotton wool. I don't want one on my bloody computer. The help system assumes you are an ILLITERATE MORON or a MANAGER and tells you how to do the same thing 6 times over in different simple internationalised bland near-English and doesn't tell you how to do what you want to do or even give an easy way of FINDING where it does. The bloody index isn't an index, just a list of keywords to the most common options, or what they think are the most common options, so you go round in circles reading the same half-dozen articles. A simple free text retrieval index (like we seem to have on all the other M$ software) would be a lot easier to use. THIS help system assumes that THEY already know what YOU want to ask and if you look for something else just tries to tell you the same thing over and over again in different words.
Anyway, I will do what I need to do in a text editor. Comma-delimited variables rule. Leave Excel for making statistically dubious bar charts to fool innumerate committees who have been told that Managers Have No Time To Read and so because they want to be Managers they sit through hour after hour of boring PowerPrickPresentations (every Presentation comes Free with a Free Corporate Logo Indoctrination Materials Anal Insertion Free Pack) to be told stuff that they could have read in 10 minutes.
No, no, that twas then., This is now. I no longer work in business. That stupidity is behind me. We don't do that here, do we? One of those things I gave up when I left the private sector. Like wearing ties, and watercoolers, and lifts that work, and 4-hour alcoholic lunchbreaks, and paying tax at a higher rate, and pretending that we cared about the company Visions and Values. Well, I never did the last one. I may be lazy, but I'm honest.
Things are different at the university. Really, they are. Here no-one cares if I don't use Excel and do it the easy way instead.