| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Needed To Find Product Cost In Another Sheet
Newbie to the world of macros and could use some help.
Basically I have on worksheet with Product and Sell Price and another with Product and Cost. I want to "find" the product cost in the one sheet and add it to my sell sheet to calculate the profit for each row... Lajos |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Needed To Find Product Cost In Another Sheet
Helo,
you can use vlookup function. like = VLOOKUP(A1,[xyz-workbook.xls]SheetName $A$1:$B1000,colnumber,FALSE) Where A1 is the product code is sell worksheet. xyz-workbook.xls is the workbook where product cost is stored. SheetName is the name of the sheet which actually contains the product cost. $A$1:$B1000 is the range where the product number and prodcut costs are actually stored in the sheet 'SheetName'. colnumber is an integer refering to the column where the costs is stored (e.g. if it is column B you replace 'colnumber' with '2') Sharad *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Needed To Find Product Cost In Another Sheet
Helo,
you can use vlookup function. like = VLOOKUP(A1,[xyz-workbook.xls]SheetName $A$1:$B1000,colnumber,FALSE) Where A1 is the product code is sell worksheet. xyz-workbook.xls is the workbook where product cost is stored. SheetName is the name of the sheet which actually contains the product cost. $A$1:$B1000 is the range where the product number and prodcut costs are actually stored in the sheet 'SheetName'. colnumber is an integer refering to the column where the costs is stored (e.g. if it is column B you replace 'colnumber' with '2') Sharad *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the lowest cost for a product from a list | Excel Worksheet Functions | |||
| Product of Hrs & minutes times rate per hr to give a cost | Excel Discussion (Misc queries) | |||
| Calculating cost of product | Excel Worksheet Functions | |||
| Calc cost pro rata (nested IF's and macro to find empty row) | Excel Worksheet Functions | |||
| How do I calculate cost of raw materials to final product? | Excel Discussion (Misc queries) | |||
Linear Mode
