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

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" <EdRob@discussions.microsoft.com> wrote in message
news:416D47A0-2F8D-490D-AEF1-61E3944F1E0A@microsoft.com...
>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
>

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" <EdRob@discussions.microsoft.com> wrote in message
> news:416D47A0-2F8D-490D-AEF1-61E3944F1E0A@microsoft.com...
> >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
> >
>
>
>

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" <EdRob@discussions.microsoft.com> wrote in message
> > news:416D47A0-2F8D-490D-AEF1-61E3944F1E0A@microsoft.com...
> > >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
> > >
> >
> >
> >