?

Log in

No account? Create an account

Previous Entry | Next Entry

Excel geekery

I just wanted to pause for a moment and say "go me" for figuring out how to find/copy an Excel macro from online and run it, using a different /much older version and platform of Excel than the one the instructions had been written for!

So I can now take a workbook full of worksheets and combine them all onto a master worksheet with a couple of clicks rather than laboriously cutting and pasting them.

(And in case you need to do this too, here's a link....)
http://www.vbaexpress.com/kb/getarticle.php?kb_id=151

People who really know Excel can make it do some mind-boggling things. I'm trying to keep track of all my Excel (and advanced InDesign) strides in Evernote, which works really well, since I don't have to remember all the steps, just that something is possible, and where to double check the "how-to."

Now, back to getting my newsletter together.

Tags:

Comments

( 20 comments — Leave a comment )
kriscat
Oct. 12th, 2011 04:03 pm (UTC)
First, I bow down to your Excel powers. :) I know enough to realize how little I realy know and be greatful I can get it to do what I need. ;)

And I don't think I've told you how much I'm enjoying Magic Mansion. I love the concept as I have a weak spot for reality shows that have talented people doing/creating something. I have a hunch that Magic Mansion would be one of my guilty pleasures if it was on tv. :)

I really love the main characters. And the age difference, the inner 'fangirl thing' Ricardo has for John, the 'fake' and 'real' magic, it all draws me into the story in the same way Psycop did.

I now want a whole series with Ricardo and Professor Topaz on a long tour in america, solving mysteries, righting wrongs and having hot sex in all fifty states. ;P
jordan_c_price
Oct. 12th, 2011 06:02 pm (UTC)
I really like the reality shows where people need to do a skill or talent, too. Although I watched one the other night that was just a bunch of people bouncing off an obstacle course, which was kind of stupid/fun, too.

I'm so glad you like the age difference. I was just reading a writing "how-to" that said people tend to write older and younger characters wrong. In the example, they had a woman in her 60's saying goofy things like, "Jumping Jehosephat!" And the editor said remember, she could have grown up listening to the Rolling Stones, and burning bras. So I'm liking when John's past starts peeking in, because he has so much past. I can totally see him and his late boyfriend all 70's glam in big collars and satin.

Edited at 2011-10-12 10:03 pm (UTC)
becky_black
Oct. 12th, 2011 05:32 pm (UTC)
I love Excel. If Excel was a person I'd sleep with them on the first date.
jordan_c_price
Oct. 12th, 2011 05:53 pm (UTC)
O_o

I'm married to Scrivener. But now I feel positively chaste and rather old-fashioned.
becky_black
Oct. 12th, 2011 05:57 pm (UTC)
LOL. I sometimes think the only reason they keep me on at work is to do Excel stuff for people. I seem to have acquired a reputation as the Excel go to gal.
jordan_c_price
Oct. 12th, 2011 06:04 pm (UTC)
It's tricky to learn because I don't know what I want to learn about until I get to a stuck point.
becky_black
Oct. 12th, 2011 06:07 pm (UTC)
Yes, that's usually how I learn new stuff. Or by accident!

Did you know there's a World Championship of Excel?
http://www.bbc.co.uk/news/technology-14401766
When I read that I was all "Why didn't I know about this?" I'd have at least been following the tournament.
jordan_c_price
Oct. 12th, 2011 11:09 pm (UTC)
That's totally fun! Society usually never celebrates anything other than sports-skills. How cool is that. (Like a spelling bee, only geekier! But the girl who won--a GIRL--is totally cute.) Onward and upward, O cute Excel girlies!
mountie123
Oct. 19th, 2011 08:22 am (UTC)
Oh goodness, I'd do the exact same thing, sleep with Excel on our first date.
marasmine
Oct. 12th, 2011 05:36 pm (UTC)
I love Excel, but I've never mastered macros. I know how good it feels when you discover how to make it do something useful. If you ever come across a way to set a cell to upper case whatever the input I'd love a link.

(I can do it easily in Basic but haven't found how to in Excel. I don't need it at the moment but it bugs me that I don't know how.)
jordan_c_price
Oct. 12th, 2011 05:57 pm (UTC)
that's just the thing someone who knew Excel well would know, too.

The "subtotal" command really rocked my world and saved me lots and lots and lots of work. I think I tried it and didn't have immediate results because I didn't understand how to do the settings. But once I did, wow!

I just wrote a little formula to take a field with first & last name and get rid of everything but the first name. But if I really knew what I was doing I could have it filter out the spots where women put "Miss" as their first name, which a lot of people who shop at my online store do. Seems to be a regional preference.
becky_black
Oct. 12th, 2011 06:17 pm (UTC)
Could use "substitute" in your formula. Either include it in your existing one, or do it in one cell then have your formula for extracting the first name work on that cell with it removed.

=SUBSTITUTE(A1,"Miss ","")

I might be barking up the wrong tree without being able to see it of course!
jordan_c_price
Oct. 12th, 2011 11:05 pm (UTC)
I will have to investigate the substitute command, I don't know a thing about it, and it might be the ticket. Thanks!!
ali_wilde
Oct. 12th, 2011 08:06 pm (UTC)
Even though you lost me halfway through the first paragraph, I just wanted to congratulate you.

I love when you can work out something - anything - on a pc without having to ask someone else. Gives a real feeling of accomplishment, no matter how big the task is.
jordan_c_price
Oct. 12th, 2011 11:02 pm (UTC)
Thank you! I was just wanting to celebrate, "Yay, I did a thing!"
ocotillo_dawn
Oct. 12th, 2011 08:26 pm (UTC)
:cool:

Excel lover here, use it for all kinds of stuff, crippled without it.

But my partner is one of those you describe. OH. MY. GOD. What he can do with Excel is astonishing. Full programming, really. He wrote a macro for me once that took one of my novels, counted every single word and how often it was used (only marginally useful, but he was practicing some new technique, and it did help me ID some words I overuse). But, yeah, that doesn't even express what he does with it. O.o!
jordan_c_price
Oct. 12th, 2011 11:04 pm (UTC)
InDesign is a lot like that if you understand GREP pattern-matching commands. You could do something in a document like, "Take all the words that end with the letter "d" and turn them purple." Only that's an easy one that I could probably program with enough futzing, trial and error.
mountie123
Oct. 19th, 2011 08:26 am (UTC)
I'm a excel baby, like for the first time yesterday I made a chart with my data. Congrats Jordan and keep us updated on your Excel wizardry.
jordan_c_price
Oct. 19th, 2011 10:50 am (UTC)
It makes me so happy to find an automated way to do something I was going to do manually! Last night I had a bunch of files open in Photoshop and I wondered if I could compile them into layers of a single document without tedious cut-and-paste. Wouldn't you know, there was a command for that! It made my night!
mountie123
Oct. 19th, 2011 10:41 pm (UTC)
I suspect that excel will become my next "learn the subject obsessively" project.
( 20 comments — Leave a comment )

Latest Month

April 2017
S M T W T F S
      1
2345678
9101112131415
16171819202122
23242526272829
30      

Tags

Powered by LiveJournal.com