Yes, Luke, there is. I have to do it with the 30 branches of my company, and
this is just part of the macro, there are more things to be done before and
after I get this values, becaming my job endless.

Well, I'll try to do it in a simple way: making the macro write this formula
and copying to the others cells. I tried it before with another formula, but
returned an error.

regards,

Dani

"Luke M" wrote:

Is there a particular reason you can't use a formula, rather than macro?
Something like this:

=IF(ISERROR(VLOOKUP(A2,Wb2_Table,3,FALSE)),"",VLOO KUP(VLOOKUP(A2,Wb2_Table,3,FALSE),Wb3_Table,2,FALS E)*24)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Dani Lima" wrote:

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