Automate Excel report to place certain data into existing report?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig Harrison - 21 Jul 2006 18:09 GMT

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.

Reply to this Message

David - 21 Jul 2006 20:32 GMT

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

Signature

David

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

Reply to this Message

Craig Harrison - 25 Jul 2006 13:54 GMT

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

> You might try looking at VLookup to get you started, if you are trying to
> find a value in various worksheets.
[quoted text clipped - 4 lines]
> > 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.

Reply to this Message

Sasa Stankovic - 22 Jul 2006 19:51 GMT

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

>I get an Excel spreadsheet report that I need to bring over the store
>number
[quoted text clipped - 4 lines]
> set
> this to automatically do what I am asking? Thank you for your help.

Reply to this Message