Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

filling down data as text or numbers from the parent tasks

Status
Not open for further replies.

duraid

Technical User
Nov 13, 2011
1
Hi all
i have a huge ms project file which contains around 6000 tasks and summary task till now
i want to insert data (in customized fields numbers or text) from the the main task (not by fill them one by one) in other word filling downwards. is there any simple VBA code to do this
all main tasks has outline level 1 so i wanna fill all cells under the main task with the same value can i do it by VBA code?
for example i have a summary task which contains 30 task i don't like to go inside tis summary tasks to fill down the same value for 30 tasks i wanna insert one value in summary task and then this value will go for the 30tasks under the main task.
thanx
ms project 2010
 
What happens if you have this

Summary task
detail task
detail task
summary task
detail task
detail task
summary task
detail task
detail task
detail task
detail task
summary task
detail task
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top