+ Reply to Thread
Results 1 to 4 of 4

Automate Excel report to place certain data into existing report?

  1. #1
    Craig Harrison
    Guest

    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.

  2. #2
    David
    Guest

    RE: Automate Excel report to place certain data into existing report?

    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.


  3. #3
    Sasa Stankovic
    Guest

    Re: Automate Excel report to place certain data into existing report?

    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 Harrison@discussions.microsoft.com> wrote in message
    news:E006A049-365F-484E-9A63-A3015E3FAFFD@microsoft.com...
    >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.




  4. #4
    Craig Harrison
    Guest

    RE: Automate Excel report to place certain data into existing repo

    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.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1