Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

How to change resp, area, wbs for multiple activities?

6 replies [Last post]
Fri, 2010-06-04 17:18
Mike Miller
User offline. Last seen 12 years 3 weeks ago. Offline
Joined: 6 May 2010
Posts: 20
Groups: None
Is there a way to change resp, area, step, and wbs for multiply activities instead of going to each activity and changing it one by one?
Top

Replies

Mon, 2010-06-07 11:09
#1
Mike Miller
User offline. Last seen 12 years 3 weeks ago. Offline
Joined: 6 May 2010
Posts: 20
Groups: None
Got it, Thanks for your help
Top
Fri, 2010-06-04 20:13
#2
Rodel Marasigan
User offline. Last seen 10 weeks 6 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Mike,
Right click on activity window and click column or press F11 then scroll down to bottom and click empty row then click triangle down and select all the columns that you need to add as sample below:
P3 Column
Top
Fri, 2010-06-04 19:24
#3
Mike Miller
User offline. Last seen 12 years 3 weeks ago. Offline
Joined: 6 May 2010
Posts: 20
Groups: None
How do I get the Resp, Step, Dept Columns to show in the activity window? As you can see I don’t have those:
Top
Fri, 2010-06-04 19:08
#4
Rodel Marasigan
User offline. Last seen 10 weeks 6 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Greg,
Like what I have mentioned, you can show those column in activity window. See sample below:
P3 Display Column
Top
Fri, 2010-06-04 18:46
#5
Mike Miller
User offline. Last seen 12 years 3 weeks ago. Offline
Joined: 6 May 2010
Posts: 20
Groups: None
Rodel,
Your options seem to be for only copying the activity description.

I’m in trying to change the options for multilply activites as seen in this image:

Image
Top
Fri, 2010-06-04 18:28
#6
Rodel Marasigan
User offline. Last seen 10 weeks 6 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Mike,
You can use 3 options:
1) Show columns of all activity codes and WBS that need to change then organize it by those group or filter it then change the first row and highlight to the last row that will require same code. Then right click and fill cell. Repeat the process on each code and each column.
2) Use Global change
3) Use export/import function in excel.
Top