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
It’s been a while since I found a true “can’t put down” book.
I have found one The Martian by Andy Weir:
The story of an astronaut left on Mars.
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.
Continue reading Hacking Sleep – What Works For Me
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