Skip to main content

Posts

Showing posts from December, 2018

Top 4 Useful Features, Tricks You Can Use In Primavera P6 || Special features To Learn In Primavera

1. How to Increase the size of icons in Primavera P6?  If you find that the menu bar and command icons are of less visibility, there is a way to increase the size of icons in Primavera P6. Let us see how to do this in this tutorial now. Go to the menu bar and under the view tab, select Toolbars and click on customize. Now a window gets opened like this, go to options tab and tick the checkbox "Large Icons". Click on the Close button and you can see that all your icons now increased in size. 2. How to Animate your Menu Bars in Primavera P6? You know that we have got the option to animate menu bars in Primavera P6. There are 4 animation options in Primavera P6, These are None  Random  Unfold Slide  Fade  You can try any of these if you want a new feel. Follow this steps to Animate Menu Bars. Click on View, go to toolbars, select Customize. Now a customize window will pop up. Go to the options tab, at Menu Animations: Check on Drop Down Bu

How To Rename Multiple Worksheets At Once With VBA Code In Excel || Excel Tricks || Rename Sheets

In this tutorial, let us learn how to rename multiple worksheets at once using VBA code in MS Excel. The common way to rename a sheet in excel is by right clicking on any sheet tab and selecting the option called Rename. But we have to do this manually one by one if we have got multiple sheets to rename. So now, in this video, let us learn how to automatically rename multiple worksheets at once using the VBA code. 1. Right click on any sheet tab, and click on View code option or press Alt+F11 to go to VBA window. 2. Insert a module and copy, paste the code as mentioned below. Sub ChangeWorkSheetName() Dim Rng As Range Dim WorkRng As Range On Error Resume Next newName = Application.InputBox(“Name”, xTitleId, “”, Type:=2) For i = 1 To Application.Sheets.Count Application.Sheets(i).Name = newName & i Next End Sub 3. Close this window and go back to Excel window 4. From the view tab of Menu bar, Select Macro and click on Run. A pop-up window will open up and enter the

Best Way To Show All Your Milestones In Primavera P6 || Easy To Focus Milestones In Schedule

In this tutorial, let us learn about the Best way to show all your milestones in Primavera P6.  A Smart layout is the one which shows all of your project milestones together in a single WBS element right at the top of the project. This will enable your top management to view the main part of your schedule clearly. So, you should add a WBS element called "Milestones" at the top of the project. Either cut and paste or move all your project milestones into the WBS element. If your schedule is of bigger size, it would be a tedious job to move all your milestones. So, now let us do this in a simple way by using Global Logic. 1. Let us open the fresh schedule, before doing anything make a copy of this project. 2. Go to Menu bar, Go to tools, select Global Logic. 3. Click on the New button, to create a new Global Change and name it as Move Milestones. 4. In the IF box, select Any of the following. Under parameter, select Activity Type and under value, select

How To Combine All Worksheets Into One Worksheet In Excel || Combine Multiple Sheets into One Sheet

In this tutorial, let us learn how to combine multiple sheets into a single workbook using a simple VBA code. This code assumes that all the worksheets have the same column headings and in the same order. This code will copy all the rows into one worksheet called Master. Steps: 1. Copy the code as mentioned Sub CopyFromWorksheets() Dim wrk As Workbook 'Workbook object - Always good to work with object variables Dim sht As Worksheet 'Object for handling worksheets in loop Dim trg As Worksheet 'Master Worksheet Dim rng As Range 'Range object Dim colCount As Integer 'Column count in tables in the worksheets Set wrk = ActiveWorkbook 'Working in active workbook For Each sht In wrk.Worksheets If sht.Name = "Master" Then MsgBox "There is a worksheet called as 'Master'." & vbCrLf & _ "Please remove or rename this worksheet since 'Master' would be" & _ "the name of the result worksheet of this

How To Create Relationships Lag Report In Primavera P6|| PRIMAVERA P6 ACTIVITY RELATIONSHIP LAG

In this tutorial let us learn how to create Relationships Lag Report in Primavera P6. What is Lag and Lead in Primavera P6? Lag is the duration that is added to a relationship as a waiting time to Start Successor Activity. If the lag is positive, it will have a wait time and if lag is negative, the successor will overlap with predecessor activity. According to the Scheduling Standards, Using Lags in a schedule is a risk. Because No one will ever understand the exact reason behind the lag except the scheduler who has prepared it and sometimes even the scheduler may forget the exact reason. So, let us learn how to create a relationship lag report in Primavera P6 now. first open the Primavera P6 1. Go to Menu bar, Tools, select Reports and click on Reports. 2. Click on Add button to add a new report 3. click Next to add a new report. 4. Select the subject area as "Activity Relationships" 5. Click Next 6. Choose columns in this dialog box as Predecessor Id,