Macro and VB development
 

I have a situation where I want to match 5,000 part numbers in one workbook
against a seoarate 10,000 master part number workbook, copy two cells from
the matched row and paste them in the original workbook row. The search would
also be a loop for the 5,000 workbook.

Where can I find an example of this type of VB coding? I have used the
"Help" from VB whic is good but am still confused. Do I need to be an expert
in VB to accomplish this task?
Would appreciate any suggestions.
Ed

Macro and VB development
 

Hi Ed Try using Excel's VLookup function.

See Excel's help or see Debra Dalgleish's tutorial at:

http://www.contextures.com/xlFunctions02.html


---
Regards,
Norman



"Ed.Rob" wrote in message
...
I have a situation where I want to match 5,000 part numbers in one workbook
against a seoarate 10,000 master part number workbook, copy two cells from
the matched row and paste them in the original workbook row. The search
would
also be a loop for the 5,000 workbook.

Where can I find an example of this type of VB coding? I have used the
"Help" from VB whic is good but am still confused. Do I need to be an
expert
in VB to accomplish this task?
Would appreciate any suggestions.
Ed

Macro and VB development
 

Hi Norman,
Thanks for the reply and it looks like this approach will be a good method
to try. I will try it tomorrow and report back.
Ed

"Norman Jones" wrote:

Hi Ed Try using Excel's VLookup function.

See Excel's help or see Debra Dalgleish's tutorial at:

http://www.contextures.com/xlFunctions02.html


---
Regards,
Norman



"Ed.Rob" wrote in message
...
I have a situation where I want to match 5,000 part numbers in one workbook
against a seoarate 10,000 master part number workbook, copy two cells from
the matched row and paste them in the original workbook row. The search
would
also be a loop for the 5,000 workbook.

Where can I find an example of this type of VB coding? I have used the
"Help" from VB whic is good but am still confused. Do I need to be an
expert
in VB to accomplish this task?
Would appreciate any suggestions.
Ed

Macro and VB development
 

Hi Norman,

Just to let you know that the approach you suggested works great and I
appreciate your help.

Ed

"Ed.Rob" wrote:

Hi Norman,
Thanks for the reply and it looks like this approach will be a good method
to try. I will try it tomorrow and report back.
Ed

"Norman Jones" wrote:

Hi Ed Try using Excel's VLookup function.

See Excel's help or see Debra Dalgleish's tutorial at:

http://www.contextures.com/xlFunctions02.html


---
Regards,
Norman



"Ed.Rob" wrote in message
...
I have a situation where I want to match 5,000 part numbers in one workbook
against a seoarate 10,000 master part number workbook, copy two cells from
the matched row and paste them in the original workbook row. The search
would
also be a loop for the 5,000 workbook.

Where can I find an example of this type of VB coding? I have used the
"Help" from VB whic is good but am still confused. Do I need to be an
expert
in VB to accomplish this task?
Would appreciate any suggestions.
Ed