All In One Spreadsheet

G

Guest

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.
 
B

Bernard Liengme

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,Sheet4!B2))
and copy down the column
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas 4
Inserting Data Repeated Times 1
Reading data from one sheet into another sheet 1
Export Excel Data to Excel Spreadsheet 2
Automatically add a column to summary sheet if another worksheet i 2
Importing Data from a pre-existing spreadsheet 2
Project Management in Excel? 1
Adding data to table that retreives data from another table 2

Top