About Ross Goodman

    Find more about me on:
  • twitter
  • googleplus
  • facebook
  • flickr
  • linkedin
  • skype
  • youtube

Here are my most recent posts

‘A Snowball’s Chance in Hell’ – Unimpossible Missions – GE – YouTube

There are a couple of other videos in this series here : https://www.youtube.com/playlist?list=PLxRhTjvLlyoIXJLwUxoQFx7Erz_FUPkJ9

 

Email Best Practices for Teams

A client asked me for our best practices around email communications, to share with their globally dispersed teams. They had learned the keys to getting to inbox zero, but their productivity was stymied by the sheer volume of unproductive emails being sent around the company. These tips were born out of the shared practices we use here at […]

from Getting Things Done® http://ift.tt/1jNswy2
via IFTTT

Fire From Moonlight

Source: Fire From Moonlight

Descending huge chimney in Pitesti – YouTube

I only had to watch the first few minutes to freak out!

This Disgusting 6-Year-Old Happy Meal Will Make You Rethink What You Eat

Looks good enough to eat?

 

Cheezburger.com – Crafted from the finest Internets.

Source: This Disgusting 6-Year-Old Happy Meal Will Make You Rethink What You Eat

Aug(De)Mented Reality 4 – YouTube

Outlook Meeting Attendees In The Invite Body

Personally I do not like the way that Microsoft Outlook prints out meetings especially the fact that attendees are a comma separated list.
I prefer to see all the attendees as a tabular list – with their acceptance response so that I can tick them off as they join the meeting.

The following macro will do this for you.
NOTE 1 : this macro is amending the text of the body of the meeting invite, if you save this and send an update – everyone will see this. I prefer to just run the macro, print the meeting and then close without saving.
NOTE 2 : this is a one off snapshot of the attendee status, if further responses or updates are received you will have to delete the old text then re-run the macro.

Continue reading Outlook Meeting Attendees In The Invite Body

Excel – Split one cell to multiple rows

There are times when you have an excel sheet which has multiple lines of text in a single cell, which has been split using a carriage return. NOTE: I’m not talking about text which has wrapped due to the size or formatting of the cell.

If you need to separate the contents of this single cell, into one row per line then this is the macro for you. NOTE: This macro will insert rows into your sheet so you may have to “fix” the layout afterwards. Save your sheet before you run this just in case.

The first function processes the current cell – use this if you only have one cell which you want to split.

If you have multiple cells which you want to split out then there is a wrapper macro which will call this multiple times.

To use, simply highlight one or more cells and then run the appropriate macro.

Excel – Unfilter all sheets

There are times when you are using an Excel workbook and you simply want to search for some content but on one of the tables on one of the sheets the table which contains the data has been filtered. You can spend more time looking for and then removing the filter than you do in running the actual search.

This macro will remove all filters from your current workbook.

Continue reading Excel – Unfilter all sheets

Automatically file Outlook Sent Items to a folder

A commenter on one of my other macros requested this functionality.

Whenever you send an e-mail in Outlook have it prompt you if you want it filed in a folder other than the default Sent Items folder.
Here it is.

Two caveats:
I’m assuming that you are using the default Sent Items folder.
You will have to edit the code to point it to the folder you wish to use.


First you have to define the event handler to monitor your sent items folder.

Now you have to add a routine to handle it.

I have a “ToDo” folder in my Personal Folders mailbox (the leading underscores are simply to “help” the sorting in the default view.

It’s this arcFolder location that you will have to adjust to your own required location.