Excel formula

Excel countif formula

 

 Whenever you need to count the elements inside data series the excel countif formula is available to help you reach your target easy and fast. The Countif formula has the following structure: =COUNTIF(Range,Condition) Note that the Range can be a large table not only one column. Examples of Excel Countif Formula Let’s say we need […]

Combobox VBA

Combobox VBA – populating with items

 

 Comboboxes are user friendly data input forms that can make the difference between a quality looking form and a archaic data input screen. Defining combobox in Excel For this step you must go to the Excel Developer menu, make sure you have this menu since it doesn’t come activated in Excel Options. Select the Insert […]

Reading from SQL

Reading from SQL table in VBA Excel

 

 Reading from SQL tables usually means that there is a need for supplementary data processing and manipulation before conclusions and information being provided to the decision making person. Excel is the best application to satisfy this need and some very useful and ergonomic reports can be developed in order to provide fresh and accurate information. […]

Excel file unsaveable

 

 Some companies use Excel files through intranet networks for all their staff to have access to certain information and automated reports. This usually means that this kind of file should be unsavable by the staff in order to preserve a certain degree of accuracy and format. Setting Excel file as unsavable Without altering the menu […]

Connecting to SQLServer VBA

Connecting to SQL Server in VBA Excel

 

 Building automated reports in Excel by connecting directly to an ERP database is a good shortcut to have fresh and accurate information to base your decisions on. This method facilitates data processing and manipulation in VBA before results and conclusions are displayed and a further availability for organizing, calculations and sorting after Excel tables are […]