Tag Archive | "cell"
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 [...]
Continue reading...How To Edit Cell With A Keyboard Shortcut In Mac Excel
Monday, February 8, 2010
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 [...]
Continue reading...
Tuesday, October 4, 2011
0 Comments