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
Bookmarks