Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-27-2018, 07:02 AM
Tris Tris is offline Dynamic based on answers? Windows 10 Dynamic based on answers? Office 2016
Novice
 
Join Date: Sep 2018
Posts: 4
Tris is on a distinguished road
Default

One of the VBA guys will be along, but simplistically, I guess you could do something in Excel and copy/paste it in to MSProject

ie create a table with all the options in the build sequence, and select those that you need in a column called "required"

Filter on those required (or use a pivot table) and paste the resultant data into Project

Ref Task Duration Required
1 Is planning permission needed 10d Yes
2 2 bed house 110d
3 3 bed house 120d Yes
4 4 bed house 140d
5 Garage 10d Yes
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
dynamic dependent drop down list based on input with reference to a two column table jwan142 Excel 4 05-23-2018 08:15 AM
Automatically color the right options in red based on the answers provided puff Word VBA 4 12-26-2017 10:36 PM
Dynamic based on answers? Need to create a "Yes/NO" Form and based on answers prompt for informatin jaradani Word 4 10-12-2014 09:42 PM
Dynamic based on answers? Conditional Formatting based on dynamic Date Modifier1000 Excel 2 09-12-2014 08:53 AM
dynamic charts based on mail merge fields jwajehee Mail Merge 0 10-05-2011 09:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft