Using data from one row in another row

CSSH · #1 03-30-2015, 06:18 AM

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?

jjmclell · #2 03-30-2015, 01:02 PM

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.

jjmclell · #3 03-30-2015, 01:23 PM

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

JulieS · #4 03-30-2015, 04:06 PM

Formulas in custom fields only refer to the current record (task)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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