Six Sigma - Black Belt


 

Comments

Post a Comment

Popular posts from this blog

Learn and Create Macros easily - Hide and Unhide sheets

Image
 Welcome to the blog.  Here we will learn and Hide and Unhide the Sheets using VBA Code in a very easy way. In this blog we will learn how to hide and unhide multiple sheets at one go using the VBA Code. We will be using the excel file used in last blog where we created multiple TABs. We will try to  learn to hide these sheets and unhide these sheets. The Code will look Like this You can copy the code from below and use it in your excel. Below code is to Hide the sheets ----------------- Sub Hide_Sheets() Tot_Sheet = ActiveWorkbook.Sheets.Count     For i = 2 To Tot_Sheet         Sheets(i).Visible = xlSheetHidden     Next i End Sub ---------- Below code is to UnHide the sheets --------- Sub Unhide_Sheets()     For Each Worksheet In ActiveWorkbook.Worksheets         Worksheet.Visible = xlSheetVisible     Next Worksheet End Sub --------- Now let us learn how to write the code with explanation Not...
Read more

Learn and Create Macros Easily - Creating multiple sheets with VBA (Macro)

Image
Welcome to the blog. Without wasting anytime we will get staraight to the point. Here we will learn and create Macros in a very easy way. In this blog we will create multiple tabs based on the Locations. Here  is the Data which we will be using to create Tabs. In this sample data, there are 10 Cities and you are tasked to create 10 Tabs with the city names. Manually it can be done. Create 10 Tabs and rename each one. Just imagine if you have 200 cities. It would be very time consuming and tiring job. Now let is create a code which will create 10 tabs and rename it with the cities. The Code will look Like this You can copy the code from below and use it in your excel ------------------------- Sub Citi_Name()          Range("A1").Select     Selection.End(xlDown).Select     TotCity = ActiveCell.Row - 1               For i = 1 To TotCity                  Tot...
Read more