Do you have hundreds or thousands of inbound emails in your Inbox with important data fields? Maybe your business is receiving leads or order confirmations by email and you find yourself doing the same manual copy & paste routine every day. If this is the case, we have a very […]
Pick Multiple Columns using Random Numbers in Excel
In one of the earlier topics we learned how to generate Random numbers in Excel & Google Spreadsheet. Now, we will see how to get values from Random Columns using the same function. This is kind of applying the Rand function little bit different application that we usually do. These […]
Sudoku Excel Download – Puzzle Solver – Free Game Help
Get Sudoku Excel download game solver. Use this Sudoku solver Excel which can generate solution for any difficult puzzle with a 9×9 matrix Sudoku game.
How to Create Data Table Excel?
Create a Table that has at least 2 columns. First column filled with test values and second column header with calculation to be tested. Select this table range, then click menu -> Data -> What-If Analysis.
Hide Desktop Icons of Active Windows Applications
Download this Free Excel application to Hide Windows or application from desktop in Windows Environment. This is built on VBA and Windows Api Programming to get Windows handle and Hide it from Desktop.
How to Lock a Folder In Windows – Easy Excel VBA Code
How to Lock a Folder in Windows 7 or Above. Use this free folder lock code in Excel vba to build your own folder locking app in just seconds.
UnLock Protected Excel Sheet – Remove Password to Unprotect
Quick tip to Unlock Protected Excel sheet without knowing its password. Crack protected excel with this VBA Macro code, Unprotect it if lost password.
Create Random Numbers in Excel and Google SpreadSheets
Get Code & Formula to generate Random numbers in Excel Sheet, VBA & Google Spreadsheets. Create Non Sequential Unexpected series of numbers.
Compare Two Excel Sheets – Highlight Differences – Macro VBA Code
Get VBA Macro to Compare Two Excel sheets & Highlight difference. Excel formula to compare Excel files & highlight differences by conditional formatting.
Application Monitor – Manage & Terminate – Tasks Manager
Task manager in Excel. Get list of applications or tasks running in Taskmanager. Bring that list into Excel & monitor the jobs running in server or your PC right from Excel itself.