How to look up each Excel workbook raw in another.

Y

Yui

Hi,

I'm wondering which platform or programming method is suitable for my usage,
Excel VBA, Access VBA or SQL query, even Sharepoint Server feature?

I have to look up each agent record of Excel workbook A in workbook B for
the corresponding customer detail.
Below is the column lists of workbook A and B. The columns of Workbook A is
a sub-set of the columns of Workbook B which have the same names.

Workbook A columns (has around 500 raws):
Day, Agent name, Agent performance;

Workbook B columns (has around 5000 raws):
Day, Agent name, Record ID, Customer record.

Appreciate you can provide any sample code, or any suggestion of a certain
programming Function.

Thanks a lot.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pulling data from one workbook to another one using VBA 0
VBA code for pasting links -- modifying RDB code for summary workbook 10
Import multiple workbooks to current workbook in specified row number 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Macro to copy certain data from one workbook into another 3
Opening a list of Excel files and run a macro in each 17
excel button to save sheet contents to new workbook 5
add lines to a order list 2

Top