Missed it by that much...

You've built a beautiful chart. Removed the Caption Bar, because we all know those are ugly. You changed the Title Settings to Divider, Left Justified. It's so beautiful that you want to copy it and use it with another metric. Just Ctrl-click and drag, but you missed the border by that much...

Try 99 times Agent 86, but you're too shaky. You should have had the small Red Bull, not the big one. That crosshair just won't stay on the border!

What to do? So simple you don't even have to click through to suffer through more bad jokes...

Just hold down Ctrl+Alt while you click and drag. You can click anywhere on the object. You can have the big Red Bull and not worry about the shakes. I wish I would have known about this a couple of years ago.

Hyperlink it!

Have you ever wanted to link to your CRM? Maybe a web site? From a table?

(For those of you who are not lucky enough to work at MarketStar, this example uses PartnerDynamics or 'PD'. MarketStar built PD to be the best partner relationship manager in the business.)

Go to Previous Sheet

Many of you use buttons to navigate among your sheets. Have you ever wanted to create a button that takes you back to the sheet you came from?


Easy-peasy.

1. Create a new variable named vSheetFrom
2. On your button that takes you to the new sheet, add a Set Variable action. In the value box, type =GetActiveSheetId()
3. On the second sheet, create a button with a Activate Sheet action. In the value box, type =vSheetFrom

Save and marvel at your cleverness.