I'm working on an estimating project and need to formulate one excel
spreadsheet that is capable of allowing me to compute three different
estimating methods. Each method will contain different columns but our
project is to have only one spreadsheet where a user can use any one of the
three estimating methods. Is there a way to do a drop down menu or anything
where I could select a method and then the columns associated with that
method would pull up? Any ideas would be greatly appreciated.