Microsoft Office Forums Dynamic based on answers?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-17-2018, 03:16 AM
ScottAnderson ScottAnderson is offline Dynamic based on answers? Mac OS X Dynamic based on answers? Office 2016 for Mac
Novice
Dynamic based on answers?
 
Join Date: Sep 2018
Posts: 2
ScottAnderson is on a distinguished road
Default Dynamic based on answers?

Hi All,


Is there a way to design a re-usable schedule that can change based on the answer to questions e.g.


Have a schedule that can be used to build a house. It's detailed and covers everything from planning permission to adding a garage. However the 2nd house already has planning permission and doesn't need a garage, so remove those sections.


We appear to be re-building schedules all the time which leads to variances in quality. I would like to build a master schedule that is linked to a questionnaire i.e.:


1: Is planning permission required?
2: 2,3 or 4 Bed house?
3: Is a garage required


Take these answers and dynamically change the schedule based on the output of the questionnaire.


Is this possible?


Regards,




Scott
Reply With Quote
  #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
  #3  
Old 09-27-2018, 02:11 PM
ScottAnderson ScottAnderson is offline Dynamic based on answers? Mac OS X Dynamic based on answers? Office 2016 for Mac
Novice
Dynamic based on answers?
 
Join Date: Sep 2018
Posts: 2
ScottAnderson is on a distinguished road
Default

Thanks...I hadn't considered that approach.
Reply With Quote
Reply

Thread Tools
Display Modes


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


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


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