you are not signed in | sign in or register
Pro-business Excel VBA Programming
Excel Macro VBA Writing Tips and Source Codes by Joel T. Protusada
Feed & Web Facts
Feed Item Count
7 Dec 16 21:39
Last Reading
RSS/XML Version
Feed Language
Feed Encoding
LNG_QR_FAILED: connection to failed (errno=111, msg=Connection refused).
Related Feeds
You could also like to visit these feeds:
    Weekly People
    Week 48
    Pro-business Excel VBA Programming
    Traffic Overview
    Newest Posts in Feed
    Data Consolidation In Excel - Part 1
    Note: We are not going to discuss here the Consolidation function of Excel. The said function is used if you want to sum up multiple numbers from different Excel files that have same format into a single Excel file. I've got limited time to post to discuss it but will try to tackle it in the near future. In this post, we will combine records from different files with different format. Appending th...
    Export To Excel
    This is the first part of our discussion on how to export data to Excel. We will start with the simplest one; how to transfer data from a flat file (CSV, Tab delimited, PSV, etc.) to Excel. Let's know first what is a flat file...What is a flat file?Wikipedia described it best...A flat file is a file that contains records, and in which each record is specified in a single line. Fields from each rec...
    Pareto Chart Example
    I will give you a very simple Pareto chart example. Create a new workbook and enter exactly the same figures in the screen shot below:The worksheet above is an example of list of reasons why you lost business proposals or quotes to other competitors. Column A has the reason descriptions. Column B has the corresponding number of times with that lost reasons in Column A. Column C has the percentages...