Primavera WBS Bands in Excel
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...
Comments
Post a Comment