Learn how to make Excel import data from another workbook using Microsoft query method in simple steps. Also learn external reference data import techniques
In Excel VBA or any programming language we have built in function to generate random number. With these functions there are possibilities that the function can generate same number any number of times. There is no limitation set on these functions. With the code in this article, we can generate… [Continue Reading]
Unit Conversion Table In Excel Download the Free Excel Unit Convertion available at end of this page to perform simple conversion of basic measurements. Units that correspond to Length, Weight & Volume can be converted with this free app. Also it has a Conversion Table within it, providing measurements to… [Continue Reading]
Select a worksheet, enter ‘=5-3’ in any cell and press Enter. Excel will calculate the difference and display result as 2. We have just entered a Formula in Cell that starts with ‘=’ sign. If we type anything in a worksheet starting with ‘=’ sign, Excel treats it as a formula, executes the formula and display the result only.
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. It will have options for Scenario Manager, Goal Seek & Data Table. Now, a Pop will ask for Row Input Cell and Column Input Cell. Choose appropriate cells for Row or Column Input. Then click ok.
Assuming Table Range is A1:E10 with numbers and need to search for a number, in this case ‘2’, then enter this Array Formula** to get the Row and Column number.
Get Code & Formula to generate Random numbers in Excel Sheet, VBA & Google Spreadsheets. Create Non Sequential Unexpected series of numbers.
Making of #N/A Error & Solve it If You are an Frequent MS Excel User, then you should have seen those Unexpected return codes from Formula that start with Hash(#). These are the Error Codes that those formula return when it could not process the Input Data or Invalid Data.This… [Continue Reading]
Learn how to use VLOOKUP with simple example. VLOOKUP usage directly in Excel and within VBA Macro code. Get VBA code to use this function in Excel Automation. A Vlookup function search for ‘value to search’ in the first column of ‘table Range’ and then returns a value from the same row.
How to Import data from Excel to Excel? Use one of the appropriate methods explained to access data from an external Excel file. Using VBA import using workbook object (closed Excel file). Using VBA read Excel file (opened workbook). Using External reference within Worksheets. Using ODBC data import option. Note:… [Continue Reading]