I'm giving Chrome a shot now. Extensions make all the difference.
I'm so evil and... skanky. And I think I'm kinda gay.
Willow ,'Storyteller'
Buffistechnology 3: "Press Some Buttons, See What Happens."
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
Gudanov - Jan 29, 2010 4:59:58 am PST #12693 of 25501
Coding and Sleeping
Jessica - Jan 29, 2010 6:03:10 am PST #12694 of 25501
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
I have a feeling I already know the answer to this one. Is there any way to sort by color in Excel?
(One of my dear colleagues in another office has ignored my instructions to use the number-code column and instead labeled her selections in yellow...on a spreadsheet of nearly 6000 lines...)
tommyrot - Jan 29, 2010 6:04:51 am PST #12695 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Hmm. I bet you could use VBA to determine the color of each cell and put the result in a new column.
Jessica - Jan 29, 2010 6:06:54 am PST #12696 of 25501
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
I found this, but I'm not sure it works in Excel 2007. I can't find the "Insert Module" function.
Vortex - Jan 29, 2010 6:08:49 am PST #12697 of 25501
"Cry havoc and let slip the boobs of war!" -- Miracleman
(One of my dear colleagues in another office has ignored my instructions to use the number-code column and instead labeled her selections in yellow...on a spreadsheet of nearly 6000 lines...)
colleague or superior? because if she's on the same level as you, send it back with a polite note asking her to do it the way that you told her to because you can't work with it this way. And cc your boss so he knows what's going on.
tommyrot - Jan 29, 2010 6:10:26 am PST #12698 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
I can't find the "Insert Module" function.
"View" / "Macros"?
Jessica - Jan 29, 2010 6:12:53 am PST #12699 of 25501
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
It's complicated. The email was sent by the SVP in that office (top of the food chain in the US offices), but I'm pretty sure the actual *work* was done by a peer of mine. I've asked her to redo it, but I expect pushback.
My immediate supervisor was on the same email chain and saw the mistake the same time I did. (Honestly, I would just assign it to the temp, but she's out until the middle of next week.)
Jessica - Jan 29, 2010 6:15:26 am PST #12700 of 25501
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
OMG! You *can* sort by cell color in 2007! I think this may be the first actual IMPROVEMENT over Office 2003 I have ever come across!
Problem solved. Copy-paste here I come.
tommyrot - Jan 29, 2010 6:18:18 am PST #12701 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
I think this may be the first actual IMPROVEMENT over Office 2003 I have ever come across!
What, you don't like the Ribbon?
(sorry)
megan walker - Jan 29, 2010 6:19:46 am PST #12702 of 25501
"What kind of magical sunshine and lollipop world do you live in? Because you need to be medicated."-SFist
One of my biggest problems with my immediate colleagues is that their knowledge of software is so basic that they can't even imagine what is possible, so they can't imagine why you would care if it was numbers vs. colors, or whatever.
Luckily, I now have backing in the assistants so we just go in and periodically clean up spreadsheets.
I will be so happy if I'm able to change groups soon.