I can beat up demons until the cows come home, and then I can beat up the cows.

Buffy ,'Dirty Girls'


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!


omnis_audis - Jan 28, 2010 11:48:13 pm PST #12691 of 25501
omnis, pursue. That's an order from a shy woman who can use M-16. - Shir

I'm guessing there is no adblock plug in for Google Chrome, huh?

ETA

Never mind. Found them.


hippocampus - Jan 29, 2010 2:30:26 am PST #12692 of 25501
not your mom's socks.

gah potential Adobe customer support fail. I got an 'your upgrade window is expiring' email and fell for it, plunking down the money for an upgrade. Now, after hours of downloads, no install because it can't find a valid serial number. I've had one qualifying system from adobe that I purchased myself, and another that came through volume licensing. I'd like to be up to speed, and the email widget seems to think that was possible. Now I'm waiting for the west coast to wake up so I can find out if they just wasted my time.


Gudanov - Jan 29, 2010 4:59:58 am PST #12693 of 25501
Coding and Sleeping

I'm giving Chrome a shot now. Extensions make all the difference.


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.