via IFTTT
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
It’s been a while since I found a true “can’t put down” book.
I have found one The Martian
The story of an astronaut left on Mars.
The Problem
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.
When your software company is called Robotoki, it only makes sense that your offices would be adorned with random robo-memorabilia. But the company’s brand new conference table, which sits atop the severed hand from some giant imaginary mech, goes beyond the call of duty. Designed and built by Tom Spina Designs, the table looks like […]
from Gizmodo UK http://ift.tt/voEe7c
via IFTTT
Categories
I Am a Math Master!
from FAIL Blog http://ift.tt/NWaN4W
via IFTTT
Being a huge fan of pools I can’t believe I missed this 50-metre-long swimmable bridge between two condo towers in Singapore. Living at the 574-apartment, 38-story-tall Sky Habitat would be my idea of hell, but I’d love to have a friend there to enjoy that roof and swim through that bridge. The mixed-use building is […]
from Gizmodo UK http://ift.tt/voEe7c
via IFTTT
via IFTTT
Categories
The Comfy Cubicle
from FAIL Blog http://ift.tt/NWaN4W
via IFTTT
via IFTTT