Adding Cost Codes
Help please! I need a macro. I have a cell with several
sets of numbers in it, i.e. 152, 143, 765, etc. Each number is a cost code that corresponds to an amount in another workbook. I need to add the corresponding amounts. I'd really appreciate any help. Thanks. |
Adding Cost Codes
Look at the vlookup function in Excel help.
=Vlookup(a1,'[MyCostcodes.xls]Codes'!$A$1:$B$200,2,False) -- Regards, Tom Ogilvy "Wrenn" wrote in message ... Help please! I need a macro. I have a cell with several sets of numbers in it, i.e. 152, 143, 765, etc. Each number is a cost code that corresponds to an amount in another workbook. I need to add the corresponding amounts. I'd really appreciate any help. Thanks. |
All times are GMT +1. The time now is 04:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com