How To Search For ID Values In A Different Worksheet With Excel VBA


This Excel VBA function allows you to take a column of values (e.g. ID numbers) in one worksheet, and use that to get corresponding values that are in a second worksheet. If you understand SQL, it’s something like: SELECT b.country FROM idtable as a, countrytable as b WHERE a.id=b.id I’ll explain the scenario further with screenshots, but basically we have one worksheet having client...

Logitech K750 Review – Best Wireless Keyboard Review


I was using the Logitech K340 keyboard for around a year. Back then, the Logitech Wireless Solar Keyboard K750 was not released yet. While the K340 keyboard was great at the start, after some time the keys would get stuck. E.g. I would be pressing down on the backspace key, and it would remain stuck, deleting not just a couple of characters, but the entire line of text. Needless to say, this was...

How To Solve The Problem Of Always Having To Log On To A Network Drive In Windows


If you try to map a network drive in Windows, and use different user credentials, you’ll realise that you’ll need to always type in the username and password every single session. If you shut down your computer everyday, that means you’ll need to do this on a daily basis. This is horrible too, if you have programs that automatically try to connect to your network drive, as...

How To Subtract 2 Count Values Using SQL Statements


If you’re developing an application that makes use of SQL statements, you may come across a time when you’ll require to count() values from a table. You may also come across a time when you’ll need to subtract a count() value from another. The good news is that you don’t have to retrieve both count() values separately and then subtract them in your application’s code...

How To Share An Wireless/Wi-Fi Internet Connection With a Windows 7 Computer


It’s not often, but sometimes you end up in an area where there’s only a wired ethernet connection to the Internet, and you have 2-3 mobile devices that only use Wi-Fi. E.g. a hotel room in China where your 3G devices don’t work. What happens? This is when you’d be happy that you had a Windows 7 computer that had the following software: Virtual Router. From the...

How To Find Out What’s Locking Files or Folders in Mac


One of the first problems that I came across the Mac was the “File in use” error that occurred whenever I tried to unmount a hard drive, or unmount a USB thumb drive. It was annoying because I didn’t know how to find the source. In Windows, I would face the same problem too, but I had a program that I used to tell me the offending application. It was handy because it would show...

How To Use jQuery with MooTools


jQuery and MooTools are 2 great javascript frameworks that allow you to incorporate some really fancy effects on your website. I was using them while I realised that I had to use both of them on a single page at one point. I didn’t realise it then, and took me nearly an hour before I realised that the two frameworks were causing some conflicts. For me, I was trying out the accordion effect...

About Author

I've over 17 years of entrepreneurship experience, having built a tech company to be the top in the country, which was subsequently acquired for an 8-figure sum. As CEO, I led the company through robust growth to 150 employees across 4 countries. After the acquisition, I embraced minimalism, sold off my personal possessions, and started living around the world.

Read more about my story here.