A way to extract info from multiple excel files, based on content?

K

Karinalex

I have multiple excel files (one for each type of contract), but I nee
to submit a report listing all active contracts by parter company (plu
the names of each contract manager, the value, etc). Each partne
company has a code it is identified by, and I am looking for a way t
extract the info based on these codes. I am familiar with macros but no
programming. Is there a simple way to do this
 
S

Spencer101

Karinalex;1603144 said:
I have multiple excel files (one for each type of contract), but I nee
to submit a report listing all active contracts by parter company (plu
the names of each contract manager, the value, etc). Each partne
company has a code it is identified by, and I am looking for a way t
extract the info based on these codes. I am familiar with macros but no
programming. Is there a simple way to do this?

Hi,

Without seeing the files (or dummy versions of) it's hard to sa
exactly. But if you have unique references you could use those t
vlookup / hlookup the necessary information from the sheets
 
G

GS

Karinalex was thinking very hard :
I have multiple excel files (one for each type of contract), but I need
to submit a report listing all active contracts by parter company (plus
the names of each contract manager, the value, etc). Each partner
company has a code it is identified by, and I am looking for a way to
extract the info based on these codes. I am familiar with macros but not
programming. Is there a simple way to do this?

To answer your Q.., 'NO'! Whether you open each file and pull the
wanted data OR use ADODB to read the data from the files (without
opening them in Excel), the process will be fairly 'non-trivial'
because you're looking only to pull certain bits of info from the
source files.

I'd go with using ADODB because I can pull 'selective' data into a
recordset via my SQL statement and 'put' that into a worksheet where I
want it to appear.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 

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

Top