#1
|
|||
|
|||
Using data from one row in another row
In the "field part" of the Gantt Chart, is it possible to let the value of a custom field depend on the value of a field in a different row? As far as I can tell it is only possible to create functions that, so to speak, operate within each row (i.e. task) individually. Is that really the case? |
#2
|
|||
|
|||
You might be able to write a macro in VBA that sets a text field to equal the value in a particular field for a different task.
For example, I think you can work with the Tasks collection object (basically the list of all your tasks) to return a field property for a particular Task object and then assign that property to the text field of another Task object. I'm rusty with my VBA or I'd try to write a quick macro up for you... If I find time, I'll try to write one and respond if no one else has. |
#3
|
|||
|
|||
Here's a quick macro I wrote that sets the value of the Text1 field for any given task to the value in the Name field for the preceding task (ignoring the first task that has no preceding task). Very simple, but you can see how this sort of thing is possible. You can then just assign the macro to a button and click it anytime you want to update...
Code:
Sub setFieldText() Dim temp As Long For temp = 2 To ActiveProject.Tasks.Count ActiveProject.Tasks(temp).Text1 = ActiveProject.Tasks(temp - 1).Name Next temp End Sub |
#4
|
|||
|
|||
Formulas in custom fields only refer to the current record (task)
|
Tags |
field, function |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Retrieving data from data base based on text selection | capitala | PowerPoint | 0 | 12-10-2014 08:10 AM |
How to replicate, consolidate and count cell data in excel for data consoldation. | Loran | Excel | 7 | 06-05-2014 01:07 AM |
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
Edit Data Source- Linking template charts to new data | lbf | PowerPoint | 0 | 10-28-2011 12:19 PM |
Powerpoint: adding data to trend lines w/o data labels | HaiLe | PowerPoint | 0 | 04-11-2011 09:21 AM |