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 IDs, and another worksheet having client IDs with their corresponding countries. The first worksheet looks like

Continue Reading

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 infuriating. So I went around, looking for

Continue Reading

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 it’ll most likely just fail. The official solution from Microsoft is to make

Continue Reading

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 – you can actually just use a single SQL to obtain this value, and this

Continue Reading

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 developer’s website: Virtual Router turns any Windows 7 or Windows 2008 R2 Computer

Continue Reading

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 me what exactly was locking

Continue Reading

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, and that caused a few compatibility issues

Continue Reading

Site Footer

Sliding Sidebar

Disclaimer

The contents on this blog are not intended as professional advice. The author disclaims any liability, loss, or risk taken by individuals who directly or indirectly act on the information contained on this blog.