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

VBA code for pasting links -- modifying RDB code for summary workbook 11
VBA to copy from one workbook into another 0
Opening a list of Excel files and run a macro in each 17
Macro to choose data and export in another workbook 20
copying to new workbook 0
Merging from an Excel file with graphics 1
Macro to copy certain data from one workbook into another 3
Another rascally VBA SUMPRODUCT issue 2

Top