Tagcell

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

H

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...

How To Edit Cell With A Keyboard Shortcut In Mac Excel

H

I was doing up several worksheets in Excel, and I was finding it incredibly disruptive to my workflow to edit a cell. I had to take my hands off my keyboard, reach out to my mouse, and double-click the cell before I could edit it. So I went searching, and turns out that there’s a keyboard shortcut for this! Just press Ctrl-U to edit the cell contents! Not sure why they chose the letter u...

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.