Automate Excel report to place certain data into existing report?

C

Craig Harrison

I get an Excel spreadsheet report that I need to bring over the store number
to and existing report. The common field for both is the client number. I get
this report every week and would like to automate the process. Right now I
have to go line by line through hundreds of stores. Is there a way I can set
this to automatically do what I am asking? Thank you for your help.
 
D

David

You might try looking at VLookup to get you started, if you are trying to
find a value in various worksheets.
 
S

Sasa Stankovic

yes, it's possible to automate such report management in excel. best way is
to use macros or, even better, VBA. But, for start, vlookup will make
finding information easier...
 
C

Craig Harrison

Please correct me if I am wrong but VLookup is not exactly an automated way
to take my report I need to write and extract data from a store report. Each
of these reports are updated daily. I would like to have some method that
would automatically synch my report and extract data from the store report.
Is this possible?

Thanks again,
Craig
 
Top