Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

LinkBack Thread Tools Display Modes
Old 01-11-2018, 07:37 AM
egyblind egyblind is offline Windows 7 32bit Office 2003
Join Date: Jan 2018
Posts: 1
egyblind is on a distinguished road
Question coppy data from sheets to master one

hello dears

please, help me to do this task, as i failed to make it allone, and i usually do it manually.
i've foldar for y17 contains 12 foldar named by month, each one contains from 20 to 25 workbooks day by day ... i want to coppy data from each workbook into mastersheet
note: every workbook contains only one sheet.
i usually use office 2003 on my pc and office 2016 on laptop, so hope code run on both.
attached a sample file for day-wb and master sheet.
thanks for your help.
Attached Files
File Type: xls form1.xls (23.0 KB, 3 views)
File Type: xls master.xls (13.5 KB, 3 views)
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Move Data from Master List to Sheets with City Name meggenm Excel 3 01-28-2016 10:18 AM
Complex calculation from multiple sheets to master sheet inreality01 Excel 49 01-06-2016 03:09 PM
Excel, transfer data from Master Sheet to sub sheets, using key word from column anvqui Excel Programming 9 06-16-2015 01:35 PM
coppy pragraph to another document romanticbiro Word VBA 1 12-01-2014 02:40 PM
How to syncronize data in two different sheets diegogeid Excel 2 09-30-2010 12:19 AM

All times are GMT -7. The time now is 06:31 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft