How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files.

Is it possible to do this in a quick way rather than doing it manually?

Enable Windows 8 on-screen keyboard on desktop PC

Is it possible to use the tablet style on-screen keyboard on a Windows 8 laptop PC? I've found the 'Ease of Access' version which runs as a desktop window but (particularly in windows store apps) would prefer to use the docked version which only appears when a text entry field is selected.

Here's the scenario: I mostly use my laptop in the traditional desktop mode, but occasionally plug it into my TV and use a wireless mouse to operate it using Netflix and other windows store apps.

find - Is there a way to give focus to Chrome search result?

It is well known that one can use Ctrl+F to find textual content in the webpage, but after I found what I need, is there a way to give focus to the search result, so that if the result is a link or a button, I can quickly click the link/button by pressing space/Enter?

Answer

In Google chrome, you can start a search in the active tab by pressing Ctrl+F Or F3, input the text you want to find and press Enter to find

You can loop through the search results by pressing the Enter.

Once you found the text you want, if its a link or a button, you can navigate to it by pressing Ctrl+Enter

Hope it helps.

Excel Scatter Chart with Labels

I have three columns of data. Column 1 has a short description, column 2 has a benefit number and column 3 has a cost. I can create a cost/benefit scatter chart, but what I want is to be able to have each point in the scatter chart be labeled with the description. I don't care if you can see it on the chart or you have to roll over the point to see the description.

Answer

You could use this addon http://www.appspro.com/Utilities/ChartLabeler.htm

Using AppleScript to Enable Snow Leopard's Text Replacement Feature

I currently use Quicksilver with a Plugin and Trigger in concert with Snow Leopard's text replacement feature (for frequently-used combinations of hashtags, due dates and other parameters) to quickly send tasks to Remember The Milk (http://www.rememberthemilk.com).

Unfortunately, I have to click "Text Replacement" from the right-click menu of the text entry field in order to use that feature. I'm suspecting that I can add some AppleScript to the Trigger as a work-around to do that automatically. If so, what would be the best way to go about this? Would I need to use GUI scripting?

windows 7 - Find all past desktop IP addresses

Is there a way to find some type of log file that saves all IP address that were assigned to a desktop?

I changed an static IP of a desktop (switched it to DHCP) of mine and i can not recall what the ip address was. Does windows log what it was anywhere?

Answer

Interesting question...

At the very least, the DHCP server should log all the addresses it hands out, if logging is enabled.

Im looking to see if its logged on the client side anywhere, but Im not seeing anything.

Program that logs the CPU usage in Windows 7

Is there any program that logs the CPU usage of all programs? I want to know, over a period of one month, which programs use the CPU more intensely.

Answer

Windows has this built-in. It's called the Performance Monitor. Create a data collector set to start collecting performance data.