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 Edit Cell With A Keyboard Shortcut In Mac Excel

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

Sliding Sidebar