Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi! everyone!
I am finishing a code, but I am not so luck with that part. What I am tring to do is: I have 3 differents workbooks, I have to find the hours to deliver each product. On the wb1 I have at least 5000 kinds of products (not all are on wb2), i have to find the products that are on wb2 and wb2 and see what is its clasification, once i did it, i have to see days to deliver on wb3 that is in days and change it to hours and return this value on wb1 at the columm "hours to delivery", the ones that are not on wb2 has to stay without the periods to deliver. I've tried a lot of times, but always there's an error with the code, and I am tired of looking for it and cant imagine what could be could u help me??? the examples are below. wb1 product Product name hours to deliver 1762 AGAMIX 20 CESTAS ? 1763 AGAMIX 425 1763 AGAMIX 425 wb2 product product name clasification 1411 ACETILENO A A 1414 HALOCARBONO 12 B 1420 ETILENO A 1422 HALOCARBONO 22 B 1423 HALOCARBONO 11 B 1425 HÉLIO ESPECIAL A 1426 HÉLIO ESPECIAL EM B wb3 Tipe of product days to deliver Special Gas Class A 7 Special Gas Class B 12 Special Gas Class C 17 Special Gas Clas D 152 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
creating a macro to find a cell value and return a statement in a | Excel Programming | |||
Find Macro across workbook | Excel Programming | |||
Find Macro across workbook | Excel Worksheet Functions | |||
Find a value in a workbook and return the worksheet name | Excel Discussion (Misc queries) | |||
macro to find a text and return a message | Excel Programming |