All In One Spreadsheet
 

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.

All In One Spreadsheet
 

Is this any help
Sheet2,Sheet3 and Sheet4 contain the three methods
In A1 (or any other cells) enter A, B or C for which method to use
In the top of column to hold info use
=IF($A$1="A",Sheet2!B2,IF($A$1="B",Sheet3!B2,Sheet 4!B2))
and copy down the column
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"DS" wrote in message
...
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.

All In One Spreadsheet
 

Send data to


see
http://www.geocities.com/excelmarksway
for Excel Demos

- - Mark

"DS" wrote:

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.