Prev: How to close file and hibernate?
Next: not enough resources
From: Yui on 30 Apr 2010 20:37
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.
From: ozgrid.com on 30 Apr 2010 22:31
Try VLOOKUP or INDEX/MATCH
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm
http://www.ozgrid.com/Excel/left-lookup.htm



--
Regards
Dave Hawley
www.ozgrid.com

"Yui" <Yui(a)discussions.microsoft.com> wrote in message
news:2E0A143B-C204-4150-98C5-7AFA2C15E28B(a)microsoft.com...
> 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.

 | 
Pages: 1
Prev: How to close file and hibernate?
Next: not enough resources