Kumar Ajit

Creating a drop down list is very easy. Its is very important function in excel if you want to select cell value from preconfigured items list and save your time in again and again typing it. For example , you are maintaining an inventory of cloths and there are 5 Size of a particular product … Read more

Hi, below is formula to place sum of above cell in every cell in a excel sheet. sum formula with-out selecting range in excel in every cell.   No need to require selection for sum.   =SUM(INDIRECT(ADDRESS(1, COLUMN()) & “:” & ADDRESS((ROW()-1), COLUMN())))

Download VBA code to Split worksheet data into multiple workbooks with pivot table.   Click here to download    

Download the Indian Salary tax computation in excel vba. Tax Computation & CTC Structure 2015-16 Click here to download

Below we will look at a program in Excel VBA that calculates the tax on an income. The following tax rates apply to individuals who are residents of India.   Download the Indian Salary tax computation in excel vba. Tax Computation & CTC Structure 2015-16     Code in open sheet Private Sub Workbook_Open() Application.ScreenUpdating = False … Read more

Inner and Outer Loops Any type of Loop can have more than one level. This is very similar to Nesting Worksheet formulas on a Worksheet. There is no limit (except memory) of the level to which you can Nest loops. To keep things simple though we will only look at a two level Loop. Let’s … Read more

For Each This Loop is slightly different from the others, but only in the fact that it requires an Object as the Variable. What it does is simply Loop though each single Object in a Collection of Objects.   Sub My_ForEach() Dim rMyCell As Range Dim iMyNumber As Integer For Each rMyCell In Range(“A1:A100”) iMyNumber … Read more

  The For Loop is perhaps the most useful of all the Loops. It runs a line or lines of code a set amount of times in any increment we set. The default increment is one. As you can see from below you must use a Variable of the Numeric type to set the amount … Read more

  Term Definition Do Required. Starts the definition of the Do loop. While Required unless Until is used. Repeat the loop until condition is False. Until Required unless While is used. Repeat the loop until condition is True. condition Optional. Boolean expression. If condition is Nothing, Visual Basic treats it as False. statements Optional. One … Read more

Again this is very similar to the Do While Loop we just used above in that it will check the condition BEFORE it enters the Loop. If the Value of iMyNumber is 0 (zero) when it reaches the Loop, the difference is the Do While would keep adding the number one to iMyNumber until it … Read more