I have just finished reviewing an excel spreadsheet where a number of the rows were formatted with strikethough : like this.
The formatting was valid and the rows have to stay there – but I have no need to review those rows. In excel you can filter rows, by contents or even by colour but not by format.
Enter a VBA user function:
I commonly have large excel spreadsheets with many tabs or worksheets within the same workbook.
I use the following Microsoft excel macro to generate a contents page.
NOTE: I’m assuming the “Contents” worksheet will be the first and the list will be generated from A2 downwards.
Private Sub CommandButton1_Click()
For i = 2 To Sheets.Count
Range("a" & i) = Sheets(i).Name
ActiveSheet.Hyperlinks.Add Anchor:=Range("a" & i), Address:="", SubAddress:="'" & Sheets(i).Name & "'!A1", TextToDisplay:=Sheets(i).Name
Next i
Columns("A:A").EntireColumn.AutoFit
End Sub
For a long while I have struggled with the amount a quality of sleep I get so I decided to address this. For years I was using a FitBit Ultra and this allowed me to track the quality and duration of my sleeping. I have made a number of changes to slowly address this problem.
I knew I had a problem when my really loud buzzy alarm clock and the TWO alarms set on my mobile phone failed to get me to wake in the morning.
I have decided to start a small series of posts where I share some of my tools, tips and tricks as to how I make my work and personal life a bit “better”.
The first of these tools is AutoHotkey.
“Fast scriptable desktop automation with hotkeys. Creating your own apps and macros has never been easier”
I’m changing mobile phone providers but I’m porting my current number to my new provider. At some point my number will stop working on my current carrier and be active on the new and I’ll have to switch sim cards at that point.
My concern is that I may not notice when this happens and I start to miss calls.
I recently stumbled across this IndieWebCamp site and I love the concepts that they are describing. Basically, you own your own content and then share it out. As I previously described in How I Make Social Media Work For Me the heart of my infrastructure was actually Google Plus and TwitterFeed to make it all connect.
I’m now going to try and make this blog the heart of this infrastructure.
In the previous series I showed you how to
Now it is time to show you how you can extract this information, with the final goal being the ability to get your (android in this case)phone polling for the data, and using it to make decisions.
In order to do this we will be using:
Google Apps Script (GAS) javascript functions to obtain values from the Google Spreadsheet where your data lives.
Google Web Services to provide a web interface to call the function and return the data over the internet.
Tasker to provide a programmatic interface on your phone to call the web service, handle the resulting data and do “something” with it.
Minimalistic Text to display the output on the home screen of your phone.
Quite often I want to create a task immediately off the back of sending an e-mail – usually to remind me to follow up with the recipient after a period of time. I created a macro to do this rather than having to remember to go into tasks and do this manually – better to keep the flow rather than having to remember the steps.
One of my New Year resolutions was to keep in touch with more people.
I also need to clear out my contact list as there are lots of “old” and incomplete entries in my Google contacts list.
Ever the productivity geek I wanted to automate this. I ended up writing the following Google Apps Script:
photo credit: Andrew Coulter Enright
If like me your Outlook calendar can get a bit hectic and others can add meetings to your calendar sometimes you end up simply “reacting” to your schedule and jumping from one appointment to the next on “autopilot”. It’s at times like these that Outlook’s ability to create a reminder can save your dignity.
However, sometimes the meeting organiser does not set a reminder. I have created an Outlook macro that will look for incoming meeting requests, without a reminder set and give you the option to set a reminder.