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

How To Change Folder Name in Android

You can create folders to store your shortcuts in your Android phone’s home scree. However, I was trying to change the folder’s name and it took me forever to discover this. Turns out, you need to first open the folder, and long-press on the title bar (it should say “New Folder” at this point). It’ll then prompt you to change the name. Urgh. Not very intuitive.

Why I Chose To Switch To Mac OS Over Windows 7?

So several people have asked me why I made the change to Mac OS, from being a Windows user for over 2 decades. Here’s why: 1. A more functional laptop I wanted a new laptop. I narrowed it down to a Lenovo, Sony or Macbook. 2 years ago, I wouldn’t even consider the Macbook, but these days the Macbooks come with a very functional touchpad, a gorgeous screen, and very comfortable keyboard. Not only that, it’s unibody design meant less

Continue Reading

Edit .htaccess to increase PHP’s max file upload

To increase the upload file size limit on your website, you need to edit PHP’s configuration settings. Unfortunately, not everyone has their own web server, so most of the time people are constrained by the limits of shared hosting. But you can still modify your base php.ini file by creating your own php.ini with the edits that you want. Your php.ini file needs to be in every folder that’s going to be affected, or at least in the folder where

Continue Reading

Sliding Sidebar