Using data from one row in another row

jjmclell · #1 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

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