Automate Excel report to place certain data into existing report?

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.

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


"Craig Harrison" wrote:

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

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...
"Craig Harrison" <Craig [email protected]> wrote in message
news:[email protected]...
>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.

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

"David" wrote:

> You might try looking at VLookup to get you started, if you are trying to
> find a value in various worksheets.
> --
> David
>
>
> "Craig Harrison" wrote:
>
> > 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.