Forum Discussion
Changing cost rate by using macro
- Uli,
You're welcome and thanks for the feedback. If I answered your question, please consider marking my response as the answer.
John
Hello,
The task is as follows:
I have material (material 1 and 2) that I sell at the price of X € /unit and buy at the price of Y € /unit.
I have stored the sales price in the Ressource: Tabelle as cost rate A (Kostensatz A), the purchase price as cost rate B (Kostensatz B).
In the Gantt chart, I have assigned the material to the tasks (Task 1 and 2). In the cost column (Kosten), I now see the values of the sales price (default in project to access cost rate A).
I have added the Kostensatztabelle (Cost Rate Table) column to the Vorgang: Einsatz (Task: Usage) view (screenshot).
The macro should now do the following: It should change all values in the column Kostensatztabelle (Cost rate table) from A to B in the view Vorgang: Einsatz (Task:Usage), so that I can see the purchase costs in the Gantt chart. It works manually.
I hope it is a little bit clearer and you understand my problem.
John
- Hi, sorry, but I cannot find the macro. Where did you post it?
Uli- It's part of the response I posted on Sept 15, part of the last paragraph.
JohnJohn, you are brilliant! This is exactly what I need! The macro runs great! Many, many thanks and have a great weekend. Be back next time, I'm sure I'll have many more questions.
Love from Germany
Uli