#1
|
|||
|
|||
Summarise information from multiple worksheets in multiple files
Hi All,
I'm a novice with Excel and new to the forum so I apologise if the post isn't clear. I have a series of excel files in one folder. Each excel file contains information about a different material property i.e. unit weight, specific gravity etc. The material property is the file name. Each file has a series of worksheets which contains information for different material types i.e. material 1, material 2 etc. The material name is the tab name. Within these worksheets I have calcuated the minimum, maximum, mean and standard deviation and these are always shown in the same cell. I would like to use a VBA script in excel, so that I select the folder location and excel opens each individual file within the folder, record the file name, and for each tab, records the tab name summarise the information shown in these cells A3&4, B3&4, C3&4, & D3&4 (note cell 3 will be text and cell 4 an number). It would ideally loop through each file in folder and summarise the information into one excel table. I was wondering whether anybody could help me out with a code to show a table like that below. Any help would be greatly appreciated Thanks File Name i.e. Unit Weight Tab 1 Name - Cell A3 - Cell A4 Tab 1 Name - Cell B3 - Cell B4 Tab 1 Name - Cell C3 - Cell C4 Tab 1 Name - Cell D3 - Cell D4 Tab 2 Name - Cell A3 - Cell A4 Tab 2 Name - Cell B3 - Cell B4 Tab 2 Name - Cell C3 - Cell C4 Tab 2 Name - Cell D3 - Cell D4 File Name i.e. Specific Gravity Tab 1 Name - Cell A3 - Cell A4 Tab 1 Name - Cell B3 - Cell B4 Tab 1 Name - Cell C3 - Cell C4 Tab 1 Name - Cell D3 - Cell D4 Tab 2 Name - Cell A3 - Cell A4 Tab 2 Name - Cell B3 - Cell B4 Tab 2 Name - Cell C3 - Cell C4 Tab 2 Name - Cell D3 - Cell D4 |
#2
|
||||
|
||||
Hi
this thread has been marked as " solved". Is this correct? There do not seem to be any answers?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Hi Pecoflyer,
No it hasn't been solved yet. Not sure where the solved icon came from. Do you know if I can remove it? Thanks |
#4
|
||||
|
||||
It's under "thread tools". I did it for you. Cheers
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
||||
|
||||
To solve your problem perhaps
http://www.rondebruin.nl/win/addins/rdbmerge.htm or http://www.rondebruin.nl/win/section3.htm might help?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
|||
|
|||
Adapted from an example at The Spreadsheet Guru for looping through files in a chosen folder.
Maybe you can make use of something like this. |
Tags |
excel vba, vba script |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to open Multiple files and copy information to a master file | gbaker | Excel Programming | 2 | 04-08-2016 08:44 AM |
Combine or merge multiple worksheets into one worksheet | timomaha | Excel | 1 | 07-21-2014 01:02 PM |
Multiple Dynamic Worksheets Consolidated into One Static Worksheet | mars1886 | Excel Programming | 3 | 02-09-2014 12:50 AM |
Sum multiple worksheets and summary tab that would sum and count by rep name | angie.chang | Excel | 1 | 05-16-2013 12:36 AM |
convert multiple csv files to multiple excel files | mit | Excel | 1 | 06-14-2011 10:15 AM |