Easy Planning

Hi Friends,   This is my First Blog , welcome you all   Now we all planners who uses Primavera are  wasting our time in transferring the program from primavera to excel , because of WBS banding is not getting copied with colors, so we have to create it by conditional formatting or some other methods but those are time consuming , Today as you saw in my video just with a single click you can make it possible with excel VBA codes which we are going to learn   Lets Start   First create a new excel file which should be macro enabled and named as "Primavera WBS bands"       Rename the sheet tab as     Copy any program for which you want to create the WBS   bands in excel   From cell E4   And now we need to create a formula which need to give as the level of WBS in the B columns   In Cell B5 write the formula as shown below   = IF(AND(E5="",F5=""),"",IF(F5="",FIND(LEFT...