Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 04-10-2017, 08:27 AM
NoSparks NoSparks is offline Summarise information from multiple worksheets in multiple files Windows 7 64bit Summarise information from multiple worksheets in multiple files Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

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.
Attached Files
File Type: xlsm Info Summary.xlsm (22.9 KB, 13 views)
Reply With Quote
 

Tags
excel vba, vba script



Similar Threads
Thread Thread Starter Forum Replies Last Post
Summarise information from multiple worksheets in multiple files 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
Summarise information from multiple worksheets in multiple files Multiple Dynamic Worksheets Consolidated into One Static Worksheet mars1886 Excel Programming 3 02-09-2014 12:50 AM
Summarise information from multiple worksheets in multiple files Sum multiple worksheets and summary tab that would sum and count by rep name angie.chang Excel 1 05-16-2013 12:36 AM
Summarise information from multiple worksheets in multiple files convert multiple csv files to multiple excel files mit Excel 1 06-14-2011 10:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft