+ Reply to Thread
Results 1 to 3 of 3

Automating Data analysis across multiple worksheets in a folder.

  1. #1
    Registered User
    Join Date
    07-25-2013
    Location
    preston
    MS-Off Ver
    Excel 2011
    Posts
    16

    Automating Data analysis across multiple worksheets in a folder.

    I am currently running a program which outputs multiple excel worksheets to a folder. I need to (at the minute manually) open each worksheet, select all the values in a column and copy them into a template worksheet. The template is then used to calculate a histogram and display the chart in a separate sheet. Also I have a statistics summary table in another sheet. Ideally I want to just get a macro to caluclate a histogram within the worksheet containing all the data and produce the summary table and and chart in separate sheets in the workbook.

    Ill attach an example of the data and the template document. I've had to cut the data down due to size, but the column of interest is O (NDVI). Ideally I want the chart title to be the same as the file name, and the summary table to shpw the date from the last column of the data (but in the right format) and the file title as the top left cell?! Hopefully all that makes sense :S It would just would make my life so much easier if it was all automated!

    Any help suggestions, or if someone could be kind enough to write a macro? (I'm clueless!) I would be hugely greatful!

    Thanks in advance,

    Alex
    NDVI STATS.xlsx1st.xls

  2. #2
    Registered User
    Join Date
    07-25-2013
    Location
    preston
    MS-Off Ver
    Excel 2011
    Posts
    16

    Re: Automating Data analysis across multiple worksheets in a folder.

    Can anyone offer any help?!
    Last edited by briggsa; 10-15-2013 at 08:22 AM.

  3. #3
    Registered User
    Join Date
    07-25-2013
    Location
    preston
    MS-Off Ver
    Excel 2011
    Posts
    16

    Re: Automating Data analysis across multiple worksheets in a folder.

    anybody? Please!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 07-14-2013, 03:13 PM
  2. Automating a pivot table for data analysis
    By LeapingLizard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2013, 06:19 PM
  3. [SOLVED] VBA code to gather data from multiple worksheets in the same folder-Master List
    By lax2734 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2012, 03:07 PM
  4. [SOLVED] Automating copying of data from different worksheets.
    By sansk_23 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2005, 11:06 AM
  5. Problem using analysis toolpack when automating EXCEL
    By Dave Gruzewski in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2005, 03:06 PM

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