Flowerstloft
New Member
- Joined
- Oct 26, 2011
- Messages
- 17
<TABLE id=post2925950 class=tborder border=0 cellSpacing=0 cellPadding=6 width="100%" align=center><TBODY><TR vAlign=top><TD style="BORDER-BOTTOM: #ffffff 0px solid; BORDER-LEFT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-RIGHT: #ffffff 1px solid" class=alt2 width=175></TD><TD style="BORDER-RIGHT: #ffffff 1px solid" id=td_post_2925950 class=alt1><!-- icon and title -->
</TD></TR></TBODY></TABLE>I am trying to consolidate a range of data from many excel files in a folder/directory into one excel file called Master Data file without opening all of the source files.
All files have the exactly same structures (the same column names...) and the data (in the souce files) is in the sheet 1 (there are Sheet 2 and 3 that are blank)
The row range of data (or number of records) in each file differ from each other
Any help would be greatly appreciated!! <!-- / message -->
</TD></TR></TBODY></TABLE>I am trying to consolidate a range of data from many excel files in a folder/directory into one excel file called Master Data file without opening all of the source files.
All files have the exactly same structures (the same column names...) and the data (in the souce files) is in the sheet 1 (there are Sheet 2 and 3 that are blank)
The row range of data (or number of records) in each file differ from each other
Any help would be greatly appreciated!! <!-- / message -->