We also use Concur, but we changed the travel booking within in it to use Amex travel, doesn't solve issue of paying a bit more for flights though always seems to come in about $20 more than booking direct!
2 May 2023
1.0K
-
I've got two spreadsheets open in excel and I want to screengrap something into one of them.
I left click in the cell where I want the screengap to appear, go to Insert > Screenshot > Screen clipping and highlight the bit I want to put into the excel sheet. And it unfailingly puts it randomly into the other spreadsheet (seemingly because that's the one I opened first).
Who do I get to kick in the balls?
-
Hitler.
-
Why don't you just save and close the one you don't want it to appear in, do your paste, and then reopen it?
-
Could you actually kick Hitler in the balls?
Was it an urban myth, or would it just be in the ball? -
Have you checked the Albert Hall?
-
Because that's just a list pasted out of another document and I don't really want to save it.
-
Correct.
Think of it as a multi centre holiday. London and Bariloche.
-
That makes no sense. Save to desktop, do the thing you need to do, delete the no longer needed file. Seems way more efficient than trying to find ways to work around the paste issue.
-
It's the way of the world now (not directing this at Simon)
People pretty much expect tech to do everything for them. At our place have people who are insulted at suggestions they just copy data from different spreadsheets into one rather than kicking off a project to build something to do it for them.
-
TBF, ff it's a commonly required function then there's potentially an efficiency to be gained from having a macro to do it for you. But in this case it seems like the workaround would take less time than posting about it on Talkback.
-
The example was simplified, but unless the macro was run by someone else, or was self aware enough to know when to run itself then people increasingly see it as beneath them to actually do the things like run a macro.
-
Sounds like it's time for a cull.
-
Spreadsheets. Macros....honestly, there's less taunting in an Arsey Nescafe thread.
-
Why do you hate spreadsheets? Let me guess, some kind of open source abacus is your tool of preference?
-
I don't hate spreadsheets. They are a very useful tool. I use one occasionally (but less so now I've moved my football admin to a database). I strongly dislike when they are used for things they are not well suited for, when they are very large, and when they are shared and used for collaborative tasks. Because in those scenarios they are not often the best tool for the job.
Something like grist is a better collaborative solution (create the data model using grist-electron, then roll out to a self-hosted instance for collaboration). But people know how to use spreadsheets, so every screw is a nail to their hammer, and they often end up bloated, slow, hard to maintain share and version, and full of errors or the potential for them.
