LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default macro to find a value and return another value on another workbook

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
creating a macro to find a cell value and return a statement in a PAG Excel Programming 7 March 14th 08 03:42 PM
Find Macro across workbook [email protected] Excel Programming 0 January 4th 06 03:59 PM
Find Macro across workbook [email protected] Excel Worksheet Functions 3 January 4th 06 02:30 PM
Find a value in a workbook and return the worksheet name Craig Excel Discussion (Misc queries) 2 August 10th 05 09:47 PM
macro to find a text and return a message jane Excel Programming 0 January 22nd 04 01:56 PM


All times are GMT +1. The time now is 10:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"