|
|
From the category archives:
Working with large amounts of information in Excel can depending on the functions used be very inefficient. One of the most useful and powerful functions for searching large amounts of data is Find and FindNext. These functions will help you scan through information and quickly source the results needed.
In this post we will describe how Find can be used to optimise your spreadsheets..
[click to continue…]
The following module is an interface which prompts the user of the document to select a text file from a pop up dialog box (similar to the Open or Save As window). Once the file is selected, the pathname and document name is recorded. This pathname/filename can then be used to automatically open the text file and further coding used to import and format the data. This macro is particularly useful for reporting purposes where data is imported on a regular basis.
{ 0 comments }
