Automate Excel report to place certain data into existing report?

[Guest]

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.

 

[Guest]

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

 

[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...

 

[Guest]

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