Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling info off a list from another sheet
I am trying to make a estimating tool/take off tool in Excel. One sheet is my
"takeoff" sheet, it has all the materials i will use, how much of each, and its price. On another sheet I have the full list of every possible material I can use, and how much each costs. I want to be able to start typing the type of material, eg- "Pipe" and all of the various types would come up on a pulldown or something, then once the correct pipe type is selected it enters the price and other information on my takeoff sheet. Is this possible in excel???? or do i have to make a database in Access??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling info off a list from another sheet
Hi Jay
You can do this with Data Validation. Take a look at Debra Dalgleish's site for more help on this topic. http://www.contextures.com/xlDataVal05.html http://www.contextures.com/xlDataVal02.html then use Vlookup of the selected item from your table of prices http://www.contextures.com/xlFunctions02.html -- Regards Roger Govier "Jay Adams" wrote in message ... I am trying to make a estimating tool/take off tool in Excel. One sheet is my "takeoff" sheet, it has all the materials i will use, how much of each, and its price. On another sheet I have the full list of every possible material I can use, and how much each costs. I want to be able to start typing the type of material, eg- "Pipe" and all of the various types would come up on a pulldown or something, then once the correct pipe type is selected it enters the price and other information on my takeoff sheet. Is this possible in excel???? or do i have to make a database in Access??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data from two sheets make up real time list in the new sheet?? | Excel Worksheet Functions | |||
auto updating list | Excel Worksheet Functions | |||
input # on sheet 1, pulls all info for # from sheet 2 | Setting up and Configuration of Excel | |||
if and then formula | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |