| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Move data from one sheet to another using drop down lists.
I am creating an accounting spreadsheet in excel 2003. One of the sheets is
all the inventory that we use. One column has the product, the next column has our cost and the third column has our retail price via a formula. On a seperate sheet that we use to creat a quote, I have a drop down list from our inventory sheet. When I select a piece of inventory i would like excel to fill in our retail cost that corresponds with that part in the inventory list in a retail cost field in our quote sheet. Is this possible and if so how?? thanks |
|
#2
|
|||
|
|||
|
Move data from one sheet to another using drop down lists.
Maybe a vlookup would be sufficient
=VLOOKUP(value_from_dropdown,Lookup_Table,2,0) -- Regards, Peo Sjoblom (No private emails please) "pwtechmn" wrote in message ... I am creating an accounting spreadsheet in excel 2003. One of the sheets is all the inventory that we use. One column has the product, the next column has our cost and the third column has our retail price via a formula. On a seperate sheet that we use to creat a quote, I have a drop down list from our inventory sheet. When I select a piece of inventory i would like excel to fill in our retail cost that corresponds with that part in the inventory list in a retail cost field in our quote sheet. Is this possible and if so how?? thanks |
|
#3
|
|||
|
|||
|
Move data from one sheet to another using drop down lists.
Sure. You can use VLOOKUP:
http://www.officearticles.com/excel/...soft_excel.htm And I have a tutorial for just such a workbook he http://www.officearticles.com/tutori...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "pwtechmn" wrote in message ... I am creating an accounting spreadsheet in excel 2003. One of the sheets is all the inventory that we use. One column has the product, the next column has our cost and the third column has our retail price via a formula. On a seperate sheet that we use to creat a quote, I have a drop down list from our inventory sheet. When I select a piece of inventory i would like excel to fill in our retail cost that corresponds with that part in the inventory list in a retail cost field in our quote sheet. Is this possible and if so how?? thanks |
|
#4
|
|||
|
|||
|
Move data from one sheet to another using drop down lists.
Thanks for the help! I will give this a try!
"Anne Troy" wrote: Sure. You can use VLOOKUP: http://www.officearticles.com/excel/...soft_excel.htm And I have a tutorial for just such a workbook he http://www.officearticles.com/tutori...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "pwtechmn" wrote in message ... I am creating an accounting spreadsheet in excel 2003. One of the sheets is all the inventory that we use. One column has the product, the next column has our cost and the third column has our retail price via a formula. On a seperate sheet that we use to creat a quote, I have a drop down list from our inventory sheet. When I select a piece of inventory i would like excel to fill in our retail cost that corresponds with that part in the inventory list in a retail cost field in our quote sheet. Is this possible and if so how?? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| Sort data from 1 work sheet into another | Excel Worksheet Functions | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
Linear Mode
