Speedy

The guy who always calls Eminem and has a problem with lyrics/behavior, etc. I imagine it's supposed to be *someone* from the label, but who is it specifically supposed to be?

With some help from the folks on here, I was able to get the macro that I needed up and running. However, I only want the macro to run on one sheet (the sheet is called "Translation"). The macro will be activated with a button on another sheet called "WorkOrder", but I only want the macro to run on "Translation" (i.e. activate from "WorkOrder", but only run from "Translation"). I'm relatively new to all of this, but is there a bit of code I can add to my macro to make it work this way? I imagine I need to add a sheet reference of some sort at the beginning of the macro? This is what it looks like right now:

Sub Copy_All_Next_To()

Dim fnd As Range

Dim rslt As Range

'

Set fnd = Range("A6") <<<do I need to add something here to reference the sheet "Translation"?>>>

Sheets("SO Database").Select

Set rslt = Cells.Find(What:=fnd.Value, _

After:=[A1], LookIn:=xlFormulas, _

LookAt:=xlWhole, _

SearchOrder:=xlByRows, _

SearchDirection:=xlNext, _

MatchCase:=False, _

SearchFormat:=False)

If rslt Is Nothing Then

MsgBox "No match found for " & fnd.Value

Exit Sub

End If

'Copy surrounding cells

On Error Resume Next

rslt.Select

For r = 0 To 0

For c = 1 To 100

rslt.Offset(r, c) = fnd.Offset(r, c)

Next c

Next r

End Sub

I appreciate all of the help!!

I would like to create a macro that will:

1) find a specified value from worksheet #1 in worksheet #2

2) after finding that value in worksheet #2, copy and paste everything next to the value from worksheet #1 next to that same value in worksheet #2

Can you help point me in the right direction for how to do this?

Seems to be almost accepted wisdom at this point, but why?

Those things seemed so useless, I'm starting to wonder whether that's even a real device, or something they made up for the show to frustrate the contestants.

I plan to switch from T-mobile to Verizon soon, and just want to know how easy it is to move a number and how long it takes.

Stallworth hasn't posted amazing stats in the last two games, but maybe he's still getting back into his groove from being out so long? 2 of my WRs are hurt this week, and these are my only two half-decent choices to put up a few points. What do you think?

Ryan is probably better overall, but he's got a tougher set of defenses to play against in the next two weeks. I'm really just trying to find someone to sub for Romo for the next three weeks (since he doesn't look to be getting much better).

I already have Romo and Witten. Is Crayton a good pickup?

Should I go with Giants or Carolina?

It seemed like Favre was taking a liking to Stuckey, but now not so sure. I covered the bye with Miles Austin (I know). I don't have great receivers, so every point counts.

Not a ton of spectacular options, but any thoughts on Rashied Davis or Michael Jenkins (or even Mike Walker)?

I have both the Giants and Carolina defenses (I picked up Carolina to cover the Giants bye last week). Which one should I use this week?

I want/need another WR, and these two are sitting on the waiver wire.

My current starters are Houshmandzadeh, Ike Hilliard, and Justin Gage. Not dropping any of these, but I have a spare RB (Mendenhall) who I'd like to replace with a WR.

I know Lloyd got hurt last game, but who's the better overall pick (assuming Lloyd's injury wasn't too serious)?

Just want to know salary

The chorus is: "When I arrive, I, I'll take you higher . . ."

Another line: "Live a lie, live a lie, live a lie!"

I've heard it on the radio a few times recently (top 40), but what's it called and who is the artist?

I have been with corporate (finance) for a few years - wondering if it will be better for my long-term career to move to a divisional finance role or to stay at corporate.

First Gillette, then Degree, now Old Spice and even Secret. Are we all getting sweatier or something?

It's a girl who sounds like a slightly shallow-voiced Amy Winehouse. The only part of the song I know is the repeated refrain in the background: "yeah, yeah, yeah". It sounds very much like something that belongs in the 1930s, but i'm sure it's relatively new. I wish I had more info, but if anybody has a clue what I'm talking about, please let me know.

It's pretty d*mn good! Especially with mustard.

I have almost completed the CPA Exam. However, I no longer work in Public Accounting (and have no desire to go back) - I now work in management finance (i.e. budgeting, planning, analysis). I do plan to finish the CPA exam since I have invested so much time and energy into it, but I was wondering if anyone has an opinion on the CMA (Certified Management Accountant) designation. Information seems to be sparse online - is it worth doing if I'm already going to be a CPA? Do employers know what it is? Is the credential useful?