need help with a macro

[Christian22]

Hi,

I habe written an macro, which compares the task in one project with tasks which are applied to a resource in the resource pool.
Now my question: I want to create a new column in the resource pool. This column must be next to the column with the resources. But also some cells of the new column have to be linked with a text which I have written in the project. And only where a task is written in the resource column shall be in the new column this text which I have save in ActiveProject.Text10
Has anybody an idea?

Thx.

P.S Sorry for the bad english, but I can`t speak English very well.

 

[PDQBach]

Your English is fine. My understanding may not be as good. Let's see if I understand.

1. In the Resource Pool you want to create a column next to the Resource Names column. Questions: (1) do you want to create it manually or using VBA? (2) To the right or the left of the Resource Names column? (For ease of reference, let's call this Resource pool column the RpText20.

2. You want to link cells in this Resource Pool column (RPtext20) with cells in a project task column. Let's call this Project column PrjText10.

This can be done but will only work if a task has a single resource assigned. If there are multiple resources then Project can't tell which Resource information to use.

To do all this manually:

1a. In the resource pool click on the column title immediately to the right of the Resource Names, press the Insert key and select the column where you want to store the text. In the discussion above I chose Text20.

1b. Now, enter any data you want in the Text20 column cells for each resource.

2a. Click once on a Resource Pool Text20 column cell that has some data.
2b. Press Ctrl+C (to copy).
2c. Switch to the Project schedule.
2d. Click *ONCE* on the Project Text10 column cell where you want the information to display.
2e. Click on Edit | Paste Special ... , click on the radio button named Paste Link and click on OK.

If you go back to the Resource pool and change the contents of the Text20 cell and then return to the Project you will see that the data has changed.

These links are very fragile. If you rename a file or move the files then the links will be broken.

 

[Christian22]

Thanks for your help.
But I have to do it with VBA.
And then I have another problem - I have this colum in the ressource pool which you called RpText20. But I have no column in the project (PrjText10 does not exist). I have saved the project name by using VBA - my projectname (that I want to fill in RpText20) is saved in ActiveProject.Text10.
And now the macro has to fill this text right next to each task which is refered to one project.